Go back and check the Analysis ToolPak one more time:

Tools addins... the checkbox must be checked.
--
Gary''s Student - gsnu200811


"Charlotte" wrote:

I have a spreadsheet which is used on multiple computers. On one there is a
#NAME error. the formula in the cell is:
=IF(B11=1,"n/a",IF(B12=1,"n/a",IF(B10B12,IF(ISODD(B12)=TRUE,B12-1,B12),B10*INT(B12/B10))))
Cell B10 can be anything from 1 upwards
Cell B11 can only be 1 or 2
Cell B12 can again be anything from 1 upwards.

I have looked through vairious settings and have ensureed that the analsys
toolkit add-in is active but I am now stumped. Any halp would be appreciated.

Thanks in advance.

Charlotte