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
|