IF statement plus multiplication

  • Thread starter Thread starter Dennis
  • Start date Start date
D

Dennis

In column A1 I have numbers that range from 1 to 10 only
and then 364.
In Column B2 I want it to do the following...
If A1 is >=200, then the amount is $40.00
If A1 is <20, then I want the number that is in A1
multiplied by $5.00

So... could someone please tell me if an "IF" statement is
the right way to accompish this, or do I need to do
something else?

Thanks
 
Hi Dennis
put the following formula in B1
=IF(A1>=200,40,A1*5)
copy this down for all rows.

Note: this formula does not check if the values in column A are
negative
Frank
 
Back
Top