if formula

[Guest]

--
Dave1125
Looking for formula for if less than $500.00 multiply by 1.5 but if over
$500.00 multiply by 1.4

 

[Guest]

Try this
=IF(A1<500,A1*1.5,A1*1.4)

 

[Gord Dibben]

=IF(H3<500,H3*1.5,H3*1.4)

=IF(H3="","",IF(H3<500,H3*1.5,H3*1.4)) to trap for H3 being blank.

You don't say what to do about exactly 500 but you change the operator to <=500


Gord Dibben MS Excel MVP

 

[Les Linton]

--
Dave1125
Looking for formula for if less than $500.00 multiply by 1.5 but if
over
$500.00 multiply by 1.4

=IF(A1<500,(A1*1.5),(A1*1.4))

Les