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.
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
