View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Simon
 
Posts: n/a
Default Help with 'named' functions **SUCCESS**

In our last episode Simon wrote:


=ybegin line=128 size=50176 name=example.xls
Attachment decoded: example.xls
=yend size=50176 crc32=1752eedb


further to this I discovered that it was only the first of the nested
functions (Cost) that was hiccuping...

All the others appear to work OK, but this one needed to be 'added' again
before it would work as expected.

I tried (unsuccessfully) adding a dummy function before this one, adding the
same function twice, and renaming the function.

In frustration, I added all the nested functions (Cost - Cost4), then deleted
Cost and added it again - SUCCESS!!

So I changed the sequence and added Cost last (instead of adding, then
deleting, then adding again) and it works as advertised...

Not sure why this might occur, but if anyone has any ideas I appreciate
hearing them...

many thanks

S