Question on Random number generation

J

Jack

I have a column of numbers, some with money values of 0.00 and others
greater than 0.00. I want to create another column that uses the values from
the first such that if the number is greater than 0, use that numer else
generate a random number between 1.00 and 12,000.00.

How would I do this?
 
N

Norman Harker

Hi Jack!

Use:
=IF(A1>0,A1,ROUND(RAND()*12000,0))

If you want two decimal places, change the last 0 to 2.
 
Top