ExcelBanter - if formula

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - if formula (https://www.excelbanter.com/excel-discussion-misc-queries/161643-if-formula.html)

Dave

if formula

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

Mike

if formula

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

Gord Dibben

if formula

=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

Les Linton

Quote:

Originally Posted by Dave (Post 568566)

--
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

All times are GMT +1. The time now is 12:41 PM.