Originally Posted by
Iamaterp
=IF(((A2=A3)*AND(I3-J2<=7)),"TRUE","FALSE")
I'll leave you to figure out the logic, but your syntax is not going to work. Here are a couple ways to proceed:
=IF(AND((A2=A3),(I3-J2<=7)),TRUE,FALSE)
=IF(A2=A3,if(I3-J2<=7,TRUE,FALSE),FALSE)
Notice also I've changed from text strings for "TRUE" and "FALSE" to the Boolean TRUE and FALSE.
- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______