=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