Question on Random number generation

  • Thread starter Thread starter Jack
  • Start date Start date
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?
 
Hi Jack!

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

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