Forum Discussion
Nested If function with multiple criteria
I guess the issue is with D19 cell. MAX() of three blank cells (with "") returns 0 (zero), not blank. Perhaps you have custom format for the cell and it shows you empty cell, not blank.
I copied your D19 value into another workbook, it gives zero.
Hi
the formula appears to work fine when I replicate it.
When you say the other cells are "blank" can you check by doing
=ISBLANK(B12)
=ISBLANK(B27)
= ISBLANK(D19)
They should all show TRUE if truly blank
They are all have formulas and they all read as False. That said, the first three conditions do result in their values being copied into the destination cell when they have data. For some reason the final condition will not populate even if I adjust the formula. So strange.
I've attached my workbook in hopes you can replicate the issue. The destination cell with the If statement in question is in D10 on the Credit Report tab. The Payment Calc tab has the four cells the If statement is targeting. Two of the cells have imbedded If formulas and the other two have imbedded Max formulas.
Hi,
In your file in formula for Credit Report D10 is just D33 if all blanks. It shall be 'Payment Calc'!D33 - as in your first message
You're right Sergei... Thanks for pointing that out. I did that this morning before I cleaned up the excel to attach to this forum. Unfortunately that wasn't the issue and the problem persists as you can probably see. Have you tested it with the corrected 'Payment Calc'!D33 statement too? It doesn't seem to work for me regardless of the last argument placed in the formula. :-(
Thanks for trying Sergei.
