Solved Can't Figure this IF formula

April 15, 2016 at 13:16:53
Specs: Windows 7
=IF(D3="T",IF(D6<5000,D7*21%,IF(D6<15000,D7*26%,D7*31%))),IF(D3="A",IF(D6<5000,D7*10%,IF(D6<15000,D7*20%,D7*30%)))
I am not sure why it is giving me an error

See More: Cant Figure this IF formula

Report •

#1
April 15, 2016 at 14:06:32
I'm not sitting in front of Excel at the moment, so I can't test anything, but it looks like you've got 2 IF formulas strung together, not a properly constructed Nested IF.

If you are trying to perform differently calculations based on D3 = "T" vs. "A", then you need to move your parenthesis around so that the formula is one long IF, not 2 IF's separated by a comma.

If you were to use the formula evaluator with D3 empty, I think that you see that the formula evaluates to FALSE,FALSE. That is not a valid "answer" so I'm guessing that you are getting a #VALUE error.

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.


Report •

#2
April 15, 2016 at 14:27:46
✔ Best Answer
You were fairly close, try this formula:

=IF(D3="T",IF(D6<5000,D7*21%,IF(D6<15000,D7*26%,D7*31%)),IF(D3="A",IF(D6<5000,D7*10%,IF(D6<15000,D7*20%,D7*30%))))

And see if you can find the difference, and if you understand it.

MIKE

http://www.skeptic.com/

message edited by mmcconaghy


Report •
Related Solutions


Ask Question