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.
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.
Nope, i didn't test - your workbook is protected. But i'll try on my own file with simular formula bit later. In general it shall work
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.
You are a GENIUS Sergei! Thank you very much!!
When I adjusted my formula to look for D9 instead of D19, and copy D19 if D9 was not empty, the problem was solved.
Thank you so very much!!! :-)
- You are welcome, no problem