ONe way:

=IF(A2<200000, A2*rate, "A2 not less than 200,000")

In article ,
Cin wrote:

I need to create a formula that basically says: If A2 is less than 200,000.00
then multiply A2 by rate.
Can anyone help the only thing I can find tells me that it is true of false
and I need the value to calculate.