Thread: nested function
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Squonk Squonk is offline
external usenet poster
 
Posts: 2
Default 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!