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 ...
E83 is the total number of days between two cells and E84 is the 90days. I was playing around in a dummy excel document to get the formula right before I copy it to the correct document I am working on. So the cells will change, but the condition will remain the same.
NerinaKouga2021Have a look at the attached file. A small example demonstrating that the formula should work. Perhaps you local system setting require a semi-colon to separate the arguments in the formula. If so, that will automatically be done when you open the file.
Thank you very much.