IF formula error - #NAME? Some get errors some not

  • Thread starter Thread starter diepvic
  • Start date Start date
D

diepvic

Hi,
Please help me, I've got a formula:
=IF($C$17>=$P38,$M38*$Z38*$U38/$C$11,IF(AND($O38<=$C$17,$C$17<$P38),IF($G38="TF",IF($C$17=EOMONTH($C$17,0),$M38*$Z38*($C$17-$O38)/$C$11,IF(EOMONTH($C$17,0)=EOMONTH($O38,0),0,$M38*$Z38*(EOMONTH($C$17,-1)-$O38)/$C$11)),0),0))

Some users get error " #NAME?" but some users find no error. The "track
error" function on the computers which occur error does not work where that
on other computers works well with value.
Moreover, the formula is copied for several cells in a column & only a few
cells result error, others do not.

Please help me with this.

Thanks so much
 
Assuming you are using 2003 or prior, it is likely that they simply don't
have the analysis toolpack installed. This function is part of that and
will return a NAME error if used without it being installed. Just try going
to Tools / Addins on a machine where it errors out and I'll bet that addin
is listed but unchecked.

Regards
Ken...............................
 
Thanks so much, Ken.
I'll try this on Monday. But I've got confused here. On the same computer,
with the same formula above, some cells appear error #Name? but some dont.
If the function "Analysis toolpack" as you said is not added in, why some
cells still got value & some dont?
Appreciate your advice
 
That would point to another issue. Hard to tell without seeing the data
really. Feel free to email me a copy of the workbook if you like and I'll
happily take a look for you. Make sure there is no sensitive data in there
if you do though. Need to take the spamtrap out of the email addy.

Regards
Ken....................
 
U'r so kind to me.

I'll check the error on Monday when back to work. If the add-in function
does not work, I'll send you the sample file.

Have a great wkend.
Thanks ;)
 
Back
Top