Random Numbers Into Text

**500bloc** · 01-19-2012, 01:06 AM

I would like to have 10 numbers compute randomly (Numbers 0-10). I would like all these numbers to come back as "No" except that the number 7 come back as "Yes". I just haven't figured out how to do it myself, lol.

**bebo021999** · 01-19-2012, 01:20 AM

A1:

=IF(RANDBETWEEN(0,10)=7,"Yes","No")

Copy downwards to A11.

**teylyn** · 01-19-2012, 02:03 AM

If you are using Excel 2003, as your profile suggests, then Randbetween() won't be available, since it is a new function in Excel 2007. In Excel 2003 and earlier you can use

=IF(INT(RAND()*10)=7,"yes","no")

cheers,

**500bloc** · 01-19-2012, 03:25 PM

Originally Posted by bebo021999

A1:

=IF(RANDBETWEEN(0,10)=7,"Yes","No")

Copy downwards to A11.

Originally Posted by teylyn

If you are using Excel 2003, as your profile suggests, then Randbetween() won't be available, since it is a new function in Excel 2007. In Excel 2003 and earlier you can use

=IF(INT(RAND()*10)=7,"yes","no")

cheers,

I am able to use RANDBETWEEN but my problem is whenever I use either formula I get a "Err:508" code. I'm still a novice at Excel so I may not be doing something correctly.

I wish to do this:

A1: Random number between 0-10 (say 5)

A2: Gives a Yes (if said number is a 7) or No depending if the randomized number is not a 7.

If someone could upload an example I would be more than appreciative.

**shg** · 01-19-2012, 02:25 AM

RANDBETWEEN is available in Excel 2003- in the Analysis Toolpak.

**teylyn** · 01-19-2012, 03:11 AM

shg, thanks for that. I thought it might be, but I wasn't sure. The laptop I'm working on does not have the Analysis ToolPak installed for 2003. I tried to activate it, but the installer files are hard-wired to my work server and I'm not in that network right now. The people who prepare our standard work laptop setups need a little kick in the shins, I guess