IF function with Criteria

[Ang3l]

Hi Friend,

Im just new here. Hope you can help me in computing rebate format.

Example. Sales x % (with Range)

Range:

10,000 to 14,999 = 1%
15,000 to 19,999 = 2%
20,000 onwards = 3%

Please help me to create formula.

Thanks,

[Tony Valko]

Not real clear.

Here's my best guess...

=Sales*IF(Sales>=20000,0.03,IF(Sales>=15000,0.02,IF(Sales>=10000,0.01,0)))

[Teethless mama]

=min(int(a1/5000-1)/100,0.03)*a1

[Ang3l]

Hi Tony,

Your understanding is correct. I try the formula. I changed "sales and rate" to cell but its not functioning.

[Ang3l]

Hi Teethless,

Sorry, I can't understand your formula.

Thanks,

[Ang3l]

Hi Tony,

Sorry, it's functioning.

Thanks,

[Ang3l]

Hi Tony,

Thank. This is a great help to me.

[Tony Valko]

You're welcome. Thanks for the feedback!

[Teethless mama]

Hi Teethless,

Sorry, I can't understand your formula.

Thanks,

No need to understand. If it works, then use it.