My Simple Nested IF() is not Working
I have done thousands of nested IF() functions much more complex than the example below but for some reason I cannot get this one to work. I'm using this formula in an archive sheet that determines what rows of the archive should appear in a report, just those that result in "Yes" in the Result column. Basically, if the value in column B is zero, I say "Yes" if the value in LastMo is equal to the value in CurMo. That works fine.
If the value in column B is non-zero, I want to get a result of "Yes" if the value in LastMo is greater than or equal to the value in B. When this condition is met I expect to get "Yes" but I end up getting a blank result.
The formula shown in row 7 in the Result column is identical to the formulas in rows 1 and 4 and again I expect it to result of "Yes". If none of the conditions in the nested IF() functions are met I should get "No" as a result.
Anyone see what I'm doing wrong? Where is the blank result coming from?
Help Article Resources
Check out the Formula Handbook template!