| 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! |
| 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 | |||
Threaded Mode
