Thread: using randombetween to arrive at dollars and cents
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Bob Arnett Bob Arnett is offline
external usenet poster
  
Posts: 48
Default using randombetween to arrive at dollars and cents
I'm trying to get a series of random monetary numbers that are between $0.01
and $99.99. Using "=randombetween(.01,99.99)" seems to only give the dollars
and makes no cents (pun intended).
The only way I've figured to do this is by using the formula
"=RANDBETWEEN(1,99)/100+RANDBETWEEN(1,99)".
Is there a more elegant way?
Reply With QuoteReply With Quote