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.