=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

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.

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

message edited by mmcconaghy

Ask Your Question

Weekly Poll

Do you trust smart speakers to not spy on you?

Discuss in The Lounge

Poll History