My current Formula is as under
Now, within same formula, if above condition is not met BUT following condition is true, then also, it should return, "New"Code:=IF(AND(Z6>=2.5,AA6>AA5,AA5>AA4),"New","Ignore")
=IF(AND(Z6>=2.5,AA6>=AA4*0.90,"New", "Ignore")
So, if either of the condition is True, like
Condition 1) =IF(AND(Z6>=2.5,AA6>AA5,AA5>AA4),"New","Ignore")
OR
Condition 2) =IF(AND(Z6>=2.5,AA6>=AA4*0.90,"New", "Ignore")
Formula should return 'New', else 'Ignore'
How to combine two criteria AND OR with IF statement in single formula? Sample File attached.
Thanks
Bookmarks