Hi!

What do you want to do if A2 = 200,000 ?

=IF(AND(A2<"",A2<200000),A2*Rate,"")

If A2 = 200,000 the formula leaves the cell blank. (not to be confused with
EMPTY)

Biff

"Cin" wrote in message
...
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.