I think you're remembering array and/or SUMPRODUCT formulas. Even after
changing the syntax to
=IF({v113,x113,z113}<"","Y","N")
Excel will not accept it, either as a regular formula or an array formula. It
highlights the V113 piece.
If the cells are supposed to be either blank or contain numbers, maybe
something like this will suffice:
=IF(COUNT(V113,X113,Z113,AB113,AD113,AH113)0,"Y", "N")
On Wed, 27 Oct 2004 16:37:08 -0700, "Todd"
wrote:
I am using an if statement and wondering if I can simplify it. I think I can
remember being able to group ifs.
Like
If(v113;x113;z113<""),"Y","N")
instead of
=IF(OR(V113<"",X113<"",Z113<"",AB113<"",AD113 <"",AH113<""),"Y","N")
Is this possible in some circumstances or am I dreaming.
Todd
|