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...
The IFS function might serve you better in this case. It's easier to construct when there are multiple conditions to check. If it's safe to assume that the numbers in E3 are always integers (no fractions), then this formula works. If you can see 2.5 arising at times, you might want to revise it. But you get the idea. Here's the formula:
=IFS(C3="Y","OK",AND(C3="N",E3>2),"Overdue",AND(C3="N",E3<=2),"Not Due")And here's a reference to study on the IFS function.