Help with IF

[mmm1106]

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

[David Biddulph]

"mmm1106" <[email protected]> wrote in
message news:[email protected]...
>
> 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

[Max]

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
>
>

[mmm1106]

thanks max - it worked!!

[Max]

Glad to hear that (from us <g>) !
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"mmm1106" wrote:
>
> thanks max - it worked!!