nested function
 

Hi,
Excel "helped" me construct this (it told me I should correct my function to
the following)

=IF(I2="",(F2&" "&G2&" "&H2),OR(IF(F2=""+AND(I2=""),(G2&" "&H2)),(F2&"
"&G2&" "&H2&", "&I2)))

But, then it just shows #VALUE! in the cell

I'm new to functions so I'm sure I've confused it (and myself).
Can anyone see something obvious that's wrong. Is it even possible to nest
in this way?
thanks!

nested function
 

I think what you are trying to do is this:

=IF(I2="",F2&" "&G2&" "&H2,IF(AND(F2="",I2=""),G2&" "&H2,F2&" "&G2&"
"&H2&", "&I2))

Hope this helps.

Pete

On Oct 17, 1:09 am, Squonk wrote:
Hi,
Excel "helped" me construct this (it told me I should correct my function to
the following)

=IF(I2="",(F2&" "&G2&" "&H2),OR(IF(F2=""+AND(I2=""),(G2&" "&H2)),(F2&"
"&G2&" "&H2&", "&I2)))

But, then it just shows #VALUE! in the cell

I'm new to functions so I'm sure I've confused it (and myself).
Can anyone see something obvious that's wrong. Is it even possible to nest
in this way?
thanks!

nested function
 

Thanks VERY much, Pete. That is precisely what I was trying to do.

I appreciate the fast response.

"Pete_UK" wrote:

I think what you are trying to do is this:

=IF(I2="",F2&" "&G2&" "&H2,IF(AND(F2="",I2=""),G2&" "&H2,F2&" "&G2&"
"&H2&", "&I2))

Hope this helps.

Pete

On Oct 17, 1:09 am, Squonk wrote:
Hi,
Excel "helped" me construct this (it told me I should correct my function to
the following)

=IF(I2="",(F2&" "&G2&" "&H2),OR(IF(F2=""+AND(I2=""),(G2&" "&H2)),(F2&"
"&G2&" "&H2&", "&I2)))

But, then it just shows #VALUE! in the cell

I'm new to functions so I'm sure I've confused it (and myself).
Can anyone see something obvious that's wrong. Is it even possible to nest
in this way?
thanks!

nested function
 

You're welcome. Thanks for feeding back - I've only just seen your
response (Google Groups is acting up again !!).

Pete

On Oct 17, 4:41 pm, Squonk wrote:
Thanks VERY much, Pete. That is precisely what I was trying to do.

I appreciate the fast response.



"Pete_UK" wrote:
I think what you are trying to do is this:

=IF(I2="",F2&" "&G2&" "&H2,IF(AND(F2="",I2=""),G2&" "&H2,F2&" "&G2&"
"&H2&", "&I2))

Hope this helps.

Pete

On Oct 17, 1:09 am, Squonk wrote:
Hi,
Excel "helped" me construct this (it told me I should correct my function to
the following)

=IF(I2="",(F2&" "&G2&" "&H2),OR(IF(F2=""+AND(I2=""),(G2&" "&H2)),(F2&"
"&G2&" "&H2&", "&I2)))

But, then it just shows #VALUE! in the cell

I'm new to functions so I'm sure I've confused it (and myself).
Can anyone see something obvious that's wrong. Is it even possible to nest
in this way?
thanks!- Hide quoted text -

- Show quoted text -