Maybe the 2nd formula should read as:
=IF(AND(G7<(TODAY()-15),I7="yes"),"OK","contract required")
i.e. I7="yes" instead of just: I7=yes
(Without the double quotes, yes would be interp'd as a defined name)
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"mmm1106" wrote:
can anyone tell me why this formula works
=IF(AND(G7<(TODAY()-15),I7=TRUE),"OK","contract required")
but this one doesn't
=IF(AND(G7<(TODAY()-15),I7=yes),"OK","contract required")
it's driving me mad...
thanks!
Mel x
--
mmm1106
------------------------------------------------------------------------
mmm1106's Profile: http://www.excelforum.com/member.php...o&userid=35786
View this thread: http://www.excelforum.com/showthread...hreadid=555505