Random funtion

[Akion]

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.

 

[Franz Verga]

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

 

[Marcelo]

Hi

=(if(round(rand()*3,0)=2,"PRESS F9",round(rand()*3,0))

HTH
regards from Brazil
Marcelo


"Akion" escreveu:

 

[Akion]

Nel post *Akion* ha scritto:



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. >.<