| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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! |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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! |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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! |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 - |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Nested And function | Excel Worksheet Functions | |||
| can you nested sum and round function within if function? | Excel Worksheet Functions | |||
| Offset function with nested match function not finding host ss. | Excel Worksheet Functions | |||
| Need help with nested function...please | Excel Worksheet Functions | |||
| Nested IF Function, Date Comparing, and NetworkDays Function | Excel Worksheet Functions | |||
Hybrid Mode
