Thread: how can i set up rand or rand between to give only -1 or 1?
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
[email protected] joeu2004@hotmail.com is offline
external usenet poster
  
Posts: 418
Default how can i set up rand or rand between to give only -1 or 1?
"Uesiet" wrote apparently:
i need a function to generate either 1 or -1 using randbetween in Exce;

=2*(RAND()0.5) - 1

Reply With QuoteReply With Quote