& if

[dave glynn]

In multiple test logic I was trying to use "and if" but found that it
wouldn't work. I then remembered "& if" which is much more elegant and
simple to use. It took me some time to remember this as in the help section
of 2003 there is no reference to & either as a function or as an operator.

Is there an update required to fix this?

Regards and thanks

Dave

 

[Luke M]

I don't think you're remember this correctly. If you want to do multiple
criteria for an IF, you can do something like
AND(A1=1,B1=2)
Thus, if a1=1 and b1=2, then true, else false. Other option is
OR(A1=1,B1=2)
meaing only if a1<>1 and b1<>2 then false.

The "&" operator is used to concatenate text, or combine text with cell
references, such as in use with the INDIRECT function.

If this doesn't help, perhaps you could post what you're trying to
accomplish as your actual goal.