In need of marital status function

[gregfetzer]

Hello all,
Can anyone help me write a function for a randomly generated marital status (M,S)?

Thanks....

[tigeravatar]

For Excel 2007 and higher:

Please Login or Register  to view this content.

The same formula can be used in Excel 2003 and lower, but you'll have to enable the Analysis Toolpak Addin

[dredwolf]

try :
=If(Randbetween(1,2)=1,"M","S")

Hopethis helps

[tigeravatar]

If you don't want to use RANDBETWEEN(), which is why the Analysis Toolpak is necessary, you can use this instead:

Please Login or Register  to view this content.

[snax]

This isn't something that needs to be done through VBA. You can place the formula below in whichever cell(s) that you want the randomly generated marital status. However, once you have them placed in all the cells that you want, I would copy all the cells and paste special values to remove the formula because it will constantly change between S and M as someone edits any cell in the file.

Please Login or Register  to view this content.

Edit:
Sorry for essentially posting the same code. I thought my page refreshed to see if there were any posts but I guess it didn't.

[Ace_XL]

Another way..

=CHOOSE(INT(RAND()*2)+1,"M","S")