formula simplification
 

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

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

Another one:

=IF(V113&X113&Z113&AB113&AD113&AH113<"","Y","N")

If all the cells are empty, then that concatenated string will be "".


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

--

Dave Peterson