Adjusting a Formula.

[Excel_77]

Hi All,

Can I add an Or statement to the below for a second criteria that if Z2 = Yes and R2<=j2 return "Review" otherwise return "--".

=IF(AND(P2>0,Z2="Yes"),"Review","--")

If possible can someone return the exact code I should use?

Thanks in advance

 

[AlphaFrog]

Try this...

=IF(AND(Z2="Yes", OR(P2>0,R2<=J2)),"Review","--")