G
Guest
i need a function to generate either 1 or -1 using randbetween in Exce;
D
David Biddulph
=-1+2*RANDBETWEEN(0,1)
B
Biff
Try this:
=CHOOSE(RANDBETWEEN(1,2),-1,1)
Biff
=CHOOSE(RANDBETWEEN(1,2),-1,1)
Biff
J
joeu2004
Uesiet said:
=2*(RAND()>0.5) - 1
V
Vijay Chary
Answer:
=(-1)^Int(Rand(2)+1)
=(-1)^Int(Rand(2)+1)
M
MartinW
Couple of observations,
1 Your formula doesn't seem to work, =RAND(2) isn't correct syntax
2 Did you realise you replied to a 2 year old post?
http://groups.google.com.au/group/m...set+up+rand+or+rand+between+#c8af7728a9ad196d
Cheers
Martin
1 Your formula doesn't seem to work, =RAND(2) isn't correct syntax
2 Did you realise you replied to a 2 year old post?
http://groups.google.com.au/group/m...set+up+rand+or+rand+between+#c8af7728a9ad196d
Cheers
Martin
V
Vijay Chary
Hi Martin !! 
Yeah, I made a mistake in the formula. It should be
==(-1)^(INT(2*RAND())+1)
How do you find out how old any post is !?
Vijay
Yeah, I made a mistake in the formula. It should be
==(-1)^(INT(2*RAND())+1)
How do you find out how old any post is !?
Vijay
M
MartinW
Hi Vijay,
I just did a Google Groups search for the subject line...
how can I set up rand or rand between to give only -1 or 1?
Which returned nothing so I cut it back to...
how can I set up rand or rand between
And there it was...
You can find Google Groups by going to the Google
homepage and clicking on the more dropdown at
the top of the page.
Cheers
Martin
I just did a Google Groups search for the subject line...
how can I set up rand or rand between to give only -1 or 1?
Which returned nothing so I cut it back to...
how can I set up rand or rand between
And there it was...
You can find Google Groups by going to the Google
homepage and clicking on the more dropdown at
the top of the page.
Cheers
Martin
D
David Biddulph
If you are using Microsoft's web interface at
http://www.microsoft.com/office/com...c.excel.worksheet.functions&lang=en&cr=USeach thread is labelled with the date of the most recent message. If you usethe + button to expand the thread, the date of each message on the thread isshown.If you use a newsreader such as Outlook Express, the date would appear bydefault in the Sent column.--David Biddulph"Vijay Chary" <[email protected]> wrote in message How do you find out how old any post is !?>> Vijay>> "MartinW" wrote:>>> Couple of observations,>>>> 1 Your formula doesn't seem to work, =RAND(2) isn't correct syntax>>>> 2 Did you realise you replied to a 2 year old post?>>http://groups.google.com.au/group/m...set+up+rand+or+rand+between+#c8af7728a9ad196d>>>> Cheers>> Martin>>>>>>>> "Vijay Chary" <[email protected]> wrote in message>> > Answer:>> > =(-1)^Int(Rand(2)+1)>> >>> > "Uesiet" wrote:>> >>> >> i need a function to generate either 1 or -1 using randbetween inExce;>>>>>>
http://www.microsoft.com/office/com...c.excel.worksheet.functions&lang=en&cr=USeach thread is labelled with the date of the most recent message. If you usethe + button to expand the thread, the date of each message on the thread isshown.If you use a newsreader such as Outlook Express, the date would appear bydefault in the Sent column.--David Biddulph"Vijay Chary" <[email protected]> wrote in message How do you find out how old any post is !?>> Vijay>> "MartinW" wrote:>>> Couple of observations,>>>> 1 Your formula doesn't seem to work, =RAND(2) isn't correct syntax>>>> 2 Did you realise you replied to a 2 year old post?>>http://groups.google.com.au/group/m...set+up+rand+or+rand+between+#c8af7728a9ad196d>>>> Cheers>> Martin>>>>>>>> "Vijay Chary" <[email protected]> wrote in message>> > Answer:>> > =(-1)^Int(Rand(2)+1)>> >>> > "Uesiet" wrote:>> >>> >> i need a function to generate either 1 or -1 using randbetween inExce;>>>>>>