formula simplification

[Todd]

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

 

[Myrna Larson]

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")

 

[Dave Peterson]

Another one:

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

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