Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Addding a Random number to a fixed number.....
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Addding a Random number to a fixed number.....
=A1+ROUND(RAND()*100,2)
and when done, copy and paste values to preserve it. -- HTH Bob Phillips (replace somewhere in email address with gmail if mailing direct) "Dermot" wrote in message ... 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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Addding a Random number to a fixed number.....
This will add the random generated number:
=INT((RAND()*90+10)*100)/100 HTH "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 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Addding a Random number to a fixed number.....
....... 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 |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
Addding a Random number to a fixed number.....
Thanks for the reply Bob,
I understand your formula thanks for this, just whatt I was looking for. Can you explain a little further please... Is the inital formula that Toppers suggested ........... 1. Incorrect? 2. Another way of doing the same thing? 3. Advantages / Disadvantages of using your formulae......if it is a correct method? Thanks again Dermot "Bob Phillips" wrote: 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 |
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
Addding a Random number to a fixed number.....
They were just another way of doing the same thing. I rounded it to two
decimal places, John multiplied it by 100 and made that into an integer then divided by 100. Same result, mines is just less convoluted, and thus more efficient <bg. But John did answer the requirement more accurately in providing a solution between 10 and 100, whereas mine gave 0 -1 100. In summary, the best answer IMO is John's last reply which combined my approach with his accurate reading, =ROUND((RAND()*90+10),2) -- HTH Bob Phillips (replace somewhere in email address with gmail if mailing direct) "Dermot" wrote in message ... Thanks for the reply Bob, I understand your formula thanks for this, just whatt I was looking for. Can you explain a little further please... Is the inital formula that Toppers suggested ........... 1. Incorrect? 2. Another way of doing the same thing? 3. Advantages / Disadvantages of using your formulae......if it is a correct method? Thanks again Dermot "Bob Phillips" wrote: 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Seed numbers for random number generation, uniform distribution | Excel Discussion (Misc queries) | |||
Random Number response | Excel Worksheet Functions | |||
Generating (in a random order)each number once from a given number | Excel Worksheet Functions | |||
random number | Excel Discussion (Misc queries) | |||
How can I get Positive values only from the random number generat. | Excel Discussion (Misc queries) |