Thread: how can i set up rand or rand between to give only -1 or 1?
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Vijay Chary Vijay Chary is offline
external usenet poster
  
Posts: 50
Default how can i set up rand or rand between to give only -1 or 1?
Answer:
=(-1)^Int(Rand(2)+1)

"Uesiet" wrote:

i need a function to generate either 1 or -1 using randbetween in Exce;
Reply With QuoteReply With Quote