Try =IF(AND(

example =IF(AND(A1="yes",(A2=TODAY())),"OK","Not OK")


Gord Dibben MS Excel MVP

On Mon, 9 Feb 2009 08:39:01 -0800, dave glynn wrote:

I was trying to use "and if" which wouldn't work. I then remembered "& if"
which did and is much more elegant and simple to use. It took some time to
come up with this solution as, in my version of 2003, there is no mention of
"&" or "& if" in the help section.

Is htere a fix required to add this?

Regards and thanks

Dave