Thread: how can i set up rand or rand between to give only -1 or 1?
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
David Biddulph David Biddulph is offline
external usenet poster
  
Posts: 618
Default how can i set up rand or rand between to give only -1 or 1?
=-1+2*RANDBETWEEN(0,1)
--
David Biddulph

"Uesiet" wrote in message
...
i need a function to generate either 1 or -1 using randbetween in Exce;


Reply With QuoteReply With Quote