excelbetter
Board Regular
- Joined
- Oct 13, 2010
- Messages
- 182
How do I setup a formula in a cell to randomly give me the result of Black or White?
Thank you.
Thank you.
How do I setup a formula in a cell to randomly give me the result of Black or White?
Thank you.
If you want to use the RAND function (instead of RANDBETWEEN), why not eliminate the call out to the ROUND function...=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")