Excel IF Statements

February 15, 2009 at 19:06:12
Specs: Windows XP
I need to write an IF statement to to determine the discount given if a client pays his fees in advance. The raw data is:
<7 day no discount
7 - 13 days 5% discount
14 - 20 days 8% discount
21+ day 10%

I have tried to write the statement as such

but to no avail.

Could you please help

See More: Excel IF Statements

Report •

February 15, 2009 at 19:35:27
There are 2 problems with the construction of your If statement.

First, the syntax of an IF statement is:

IF(logical_test, value_if_true, value_if_false)

So, when writing a Nested IF such as yours, the second IF has to be the value_if_false for the first IF since the second IF is what you want Excel to look at if the value of the first IF is FALSE, and so on.

As an example,


Second, if you want to check if a value is between 2 numbers, you have to use an AND statement to get a TRUE or FALSE.

will be TRUE for values from 1 to 10.

So combining both of those concepts we get:


Hope that helps.

Report •

February 21, 2009 at 20:41:33
Thank you for your input...I found it very helpful and beneficial to my understanding of excel.

Report •

February 21, 2009 at 21:28:36
Glad to have helped. Thanks for the feedback.

Report •

Related Solutions

February 23, 2009 at 22:25:04
By the way, if you want to learn more about AND formulas and nested IF statements, please visit www.excelinfinance.com

Report •

Ask Question