Excel if statement question

[mlavery96]

I need assistance with an excel if statement.

I need to return a calculation to a given field that is based on one of five different values.  The end calculation will have a different multiplier as well.   This is being used to determine potential lease payments, based on the total purchase price, and a rate amount.   The details are as follows:
Purchase price up to $25,000 will have a .03287 multiplier, between $25,001 and $75,000 the multiplier is .03251, between $75,001 and $100,00 the multiplier is .03215, between $100,001 and $300K the multiplier is .03178 and between $300,001 and $500K the multiplier is .03178.

The ending output will be a $ amount that is calculated on an input field.  for example the total input into Cell D32 is $58,999, the corresponding output will be $1,918.05.

What would this if statement look like?

Thanks...

[indyblue250]

I have no idea as I havent worked with excel forever; just make sure you use the "IF" function

[soybean]

This would be a very complicated formula, so I'm not going to try to develop the full statement.  I'm just going to suggest you search Excel's Help on nesting functions.  Unless there's another approach I'm not aware of, you're gong to need to create a long, complicated formula with nested functions.  By nesting, I mean putting an IF statement within an IF statement, which also contains an IF statement, etc.   Other logical functions such as AND, OR, and NOT may also be useful here.

[soybean]

I went ahead and tested a formula.  Here's what I came up with, where B1 is the input cell:

=IF(B1<25000,B1*0.03287,(IF(B1<=75000,B1*0.03251,IF(B1<=100000,B1*0.03215,(IF(B1<=300000,B1*0.03178,B1*0.03178))))))

I stopped at 300000 because you show the same multiplier between $100,001 and $300K and between $300,001 and $500K.  In other words, any amount over $100,001 is subject to a multiplier of .03178.

[mlavery96]

Soybean,

Thnaks.  I new the formula was a nested formula, my error came with the last nested "If" statement.

Many Thanks.