Analysis toolpak
Posted by IML on October 02, 2001 11:12 AM
Simple question: If I email a worksheet to someone using an add in formula, will it return a #name? error if the end user doesn't have it installed? I need to send some one a working "live" sheet and I don't have the means to test this.
Thanks in advance,
Ian
Posted by Mark W. on October 02, 2001 11:14 AM
Yes... the same results you'll get if you remove
the add-in from your configuration if you'd like
to see it for yourself.
Posted by IML on October 02, 2001 11:18 AM
Shoot. And Thanks. (NT)
Posted by Aladin Akyurek on October 02, 2001 11:22 AM
You might...
try to replace all formulas that use add-in functions with formulas that use default functions, if you can get away with it.
Posted by IML on October 02, 2001 11:30 AM
Re: You might...
Good idea. I will be working on =workday().
Posted by IML on October 02, 2001 11:52 AM
Re: You might...
=WORKDAY(A1,1,holiday)
seems to equal
=A1+1+((WEEKDAY(A1)=6)*2)+(WEEKDAY(A1)=7)+(ISNUMBER(MATCH(A1+1+((WEEKDAY(A1)=6)*2)+(WEEKDAY(A1)=7),holiday,0)))
Posted by Aladin Akyurek on October 02, 2001 12:56 PM
Re: You might...
Ian --
That's real nice. The "holiday" part may give trouble though if MATCH hits a holiday that is followed up one ore more consecutive holidays.
Lets assume the following holiday range of values:
{35465;35466;35467}
In A1 enter: 02-Feb-01
If your holiday range does not contain protracted holidays, the formula would serve its purpose.
Aladin
