Creating a Formula
What if it is not less than 200,000?
If you require it to remain the same: (if the rate is in A3)
=IF(A2<200000,A2*A3,A2)
--
Kind regards,
Niek Otten
"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.
|