Forum Discussion
Solved
Nested IF and OR
Hi everyone I have successfully created a nested IF with AND statement, but realized after completion that I forgot to check for a new variable. When I try to add the new variable into the equatio...
loumar1 Since the numerical value for the date January 0, 1900 equals to zero, you can wrap your entire formula in one more IF statement.
=IF( X2=0, "Not applicable" , <your formula with the = sign> )
loumar1 Since the numerical value for the date January 0, 1900 equals to zero, you can wrap your entire formula in one more IF statement.
=IF( X2=0, "Not applicable" , <your formula with the = sign> )
- Thank you very much, I just tried your recommendation and it worked.
I thought I had tried your suggestion previously, but was getting errors
Thank you
