|Let's start with the comma vs. semi-colon issue.|
Based on this website, I believe this to be a Windows 7 setting, specifically the "List Separator" character.
Since I am running a US English based version of Windows XP with Excel 2010, I need to use commas.
Regardless of whether a comma or semicolon is used, the syntax for a Nested IF is the same. Since I can't test anything with a semi-colon, I'll leave it to you to make those changes.
That said, let's look at the formula that you posted in your latest response:
=IF(E10>4000; E10*0.15; 0 IF(E10>2000; E10*0.05; 0))
Why do you have a 0 before the second IF clause? That is sure to cause an error.
Now let's look at mine:
=IF(E10>4000, E10*0.15, IF(E10>2000, E10*0.05, 0))
Follow the logic of my formula as it relates to the logical flow of an IF statement:
IF(logical_test, [value_if_true], [value_if_false])
Logical Test for 1st IF:
value_if_true for 1st IF:
value_if_false for 1st IF:
IF(E10>2000, E10*0.05, 0)
Logical Test for 2nd IF:
value_if_true for 2nd IF:
value_if_false for 2nd IF:
Here is a table of values returned using my formula:
E10: 2000 0 Not greater than 2000, so no discount
E10: 2001 100.05 Greater than 2000: 2001*.05 = 100.05
E10: 4000 200 Not greater than 4000, 4000*.05 = 200
E10: 4001 600.15 Greater than 4000: 4001*.15 = 600.15
Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.