error in excel slope function

gjlipman · May 1st, 2004, 4:39 am

for some reason, when I use the formula=SLOPE({0.03965;0.03605;0.03325},{0.0225;0.0225;0.0225}) it gives me a value of 0, whereas it should give me a value of #NA. It also seems pretty unpredictable, sometimes it gives me a 1, or anything in between. I couldn't see this problem documented anywhere on the microsoft site - does anyone know what is causing it? I guess it seems to be a flaw in the way that excel handles lines with infinite slope?Thanks,

Oinker · May 3rd, 2004, 11:07 am

Laet night (5.2) I visited the MS Downloads site looking for upddates, patches, etc. and I vaguely remember downloaded something that acknowledged that Excel sometimes "sometimes gets it wrong" (No!....Really!?!) using SLOPE() and a few other regression like functions. Perhaps you are experienceing the same. Hope this can help you out... Usually I never read the info -- I just download the stuff and forget about it. For some reason this caught my eye...Good Luck

kenzo · May 3rd, 2004, 3:22 pm

I had the same problem, what you need is an update: Excel 2003 KB834691.HTH

gjlipman · May 3rd, 2004, 9:10 pm

hmmm. But I'm working in excel 2002, so that shouldn't be the problem.