Forum Discussion
IF Statement Formula -
Hi All, I am trying to create a formula which basically checks my cell C3 if it is a "Y" or "N" If it is a "Y" I need the cell to return "Ok" if it is "N" I then need the cell to look in cel...
JMExcel2023 Perhaps:
=IF(C3="Y", "Ok", IF(E3 >= 3, "Overdue", "Not Due"))
or
=IFS(C3="Y", "Ok", E3>=3, "Overdue", TRUE, "Not Due")
You might want to change ">=" to ">", or add a separate result for E3=3. Your description is ambiguous.