Remember Me?

#1
October 28th 04, 12:37 AM
 Todd Posts: n/a
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")

Is this possible in some circumstances or am I dreaming.

Todd

#2
October 28th 04, 01:03 AM
 Myrna Larson Posts: n/a

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:

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

Is this possible in some circumstances or am I dreaming.

Todd

#3
October 28th 04, 01:49 AM
 Dave Peterson Posts: n/a

Another one:

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

Is this possible in some circumstances or am I dreaming.

Todd

--

Dave Peterson

 Posting Rules Smilies are On [IMG] code is On HTML code is OffTrackbacks are On Pingbacks are On Refbacks are On

 Similar Threads Thread Thread Starter Forum Replies Last Post Don't be a pain in the ass Setting up and Configuration of Excel 0 January 24th 05 01:49 PM Mally Excel Discussion (Misc queries) 5 January 21st 05 01:07 PM circeo Excel Discussion (Misc queries) 3 January 17th 05 09:04 PM Alida Andrews Excel Discussion (Misc queries) 2 January 6th 05 09:02 PM Anthony Slater Excel Discussion (Misc queries) 3 January 4th 05 03:03 PM

All times are GMT +1. The time now is 12:21 PM.