Forum Discussion
IF Statement in excel
I am trying to do a IF statement to flag when a number of days between to dates exceeds 90 day, but I am struggling and keep getting error. =IF(E83>E84,”Validity close to Expiry”,”Valid”). What am I ...
=IF(E83>=E84,”Validity close to Expiry”,”Valid”
Check the quotes in the formula, or better put new ones if the formula is a copy.
Enclosed in the inserted file are two further suggested solutions.
Thx
Nikolino
- Thank you very much.
