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

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

"Dave" wrote:


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

=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

On Wed, 10 Oct 2007 17:21:01 -0700, Dave wrote:

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