Franz Verga Wrote:
Nel post
*Akion* ha scritto:
HI i've got a small peice of work which requires a spread sheet to
show a random value of 1, 3 or 0 but not 2 the formular i have so
far
is =ROUND(RAND()*3,0) cana ny one direct me to my mistake as i am
rather amatuerish at excels functions.
Hi Akion,
try this formula:
=CHOOSE(INT(RAND()*3+1),0,1,3)
--
Hope I helped you.
Thanks in advance for your feedback.
Ciao
Franz Verga from Italy
Thank you for your help your a life saver. .<
--
Akion
------------------------------------------------------------------------
Akion's Profile:
http://www.excelforum.com/member.php...o&userid=35713
View this thread:
http://www.excelforum.com/showthread...hreadid=554965