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