& if

  • Thread starter Thread starter dave glynn
  • Start date Start date
D

dave glynn

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

In my Excel 2003 help system I have this:

Text operator Meaning (Example)
& (ampersand) Connects, or concatenates, two values to produce one
continuous text value ("North"&"wind")
 
Try =IF(AND(

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


Gord Dibben MS Excel MVP
 
Back
Top