Solved Can't Figure this IF formula

April 15, 2016 at 13:16:53
Specs: Windows 7
I am not sure why it is giving me an error

See More: Cant Figure this IF formula

Report •

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 •

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


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


message edited by mmcconaghy

Report •

Related Solutions

Ask Question