How to produce a tiered discount schedule

Hi Ryan,

Thank you for your question and welcome to the forum.

Cell F4 represents the value entered which then returns the corresponding percentage. You keep nesting IF's until you only have one possible answer left and then use it.

You could try this formula which is known as a nested IF:

=IF(F4<=100,5%,IF(F4<=200,10%,IF(F4<=300,15%,20%))). There is a limit of 64 ifs.

Another approach might be to use the Index and Match functions to return appropriate values as well. You should look into these functions. Please have a look at the link below:

http://www.contextures.com/xlFunctions03.html

I hope this answers your question.

Regards

Simon