View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
Bob Phillips Bob Phillips is offline
external usenet poster
 
Posts: 10,593
Default Addding a Random number to a fixed number.....

Good spot, I missed the 10 min.

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"Toppers" wrote in message
...
...... as Bob's reply ..

=ROUND((RAND()*90+10),2)

"Dermot" wrote:

Is there a way to add any randomly generated number between 10 and 100

(to
two decimal places) to a Varying figure in a cell.........

For Example.....
2800 + 89.21 = 2889.21

Another Example...
3000 + 21.67 = 3021.67