| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Help with IF
Glad to hear that (from us <g) !
-- Max Singapore http://savefile.com/projects/236895 xdemechanik --- "mmm1106" wrote: thanks max - it worked!! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Linear Mode
