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