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.


--
Akion
------------------------------------------------------------------------
Akion's Profile: http://www.excelforum.com/member.php...o&userid=35713
View this thread: http://www.excelforum.com/showthread...hreadid=554965

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

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

Hi

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

HTH
regards from Brazil
Marcelo


"Akion" escreveu:


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.


--
Akion
------------------------------------------------------------------------
Akion's Profile: http://www.excelforum.com/member.php...o&userid=35713
View this thread: http://www.excelforum.com/showthread...hreadid=554965