Joy is over-rated, let's settle for the absence of misery.

If the user puts:
=ISODD(2)
does the cell display FALSE or #NAME ??
--
Gary''s Student - gsnu200811


"Charlotte" wrote:

Thank you Gary,

Unticked and reticked a couple of times , saved spreadsheet and not.

Still no joy.

Charlotte

"Gary''s Student" wrote:

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