Help with IF
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 |
Help with IF
"mmm1106" wrote in
message ... 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... Because unless you have defined yes as a name, Excel doesn't recognise it. If you want to look for yes as a text string, you need to put it in double quotes, just as you've done with the strings "OK" and "contract required". By contrast, TRUE is a logical value which Excel recognises. -- David Biddulph |
Help with IF
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 |
Help with IF
thanks max - it worked!! -- mmm1106 ------------------------------------------------------------------------ mmm1106's Profile: http://www.excelforum.com/member.php...o&userid=35786 View this thread: http://www.excelforum.com/showthread...hreadid=555505 |
Help with IF
Glad to hear that (from us <g) !
-- Max Singapore http://savefile.com/projects/236895 xdemechanik --- "mmm1106" wrote: thanks max - it worked!! |
All times are GMT +1. The time now is 10:05 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com