Random text value?

[excelbetter]

How do I setup a formula in a cell to randomly give me the result of Black or White?

Thank you.

 

[chrism216]

How do I setup a formula in a cell to randomly give me the result of Black or White?

Thank you.

=IF(ROUND(RAND(),0),"White","Black")

 

[pgc01]

Hi

For ex.:

=IF(RANDBETWEEN(0,1),"Black","White")

 

[excelbetter]

Perfect. Thank you.

 

[Rick Rothstein]

=IF(ROUND(RAND(),0),"White","Black")

If you want to use the RAND function (instead of RANDBETWEEN), why not eliminate the call out to the ROUND function...

=IF(RAND()<0.5,"Black","White")

 

[chrism216]

If you want to use the RAND function (instead of RANDBETWEEN), why not eliminate the call out to the ROUND function...

=IF(RAND()<0.5,"Black","White")

Nice!