View Single Post
  #2   Report Post  
Niek Otten
 
Posts: n/a
Default 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.