=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