intercept and slope functions

M

midbond

I'm using Vista and Office 2007. I have formulas using intercept and slope
calcs, but they are now coming up as DIV/0. Thre are no "0"s in the list and
I have the addins activate. What am I missing
 
M

MartinW

Hi midbond,

In earlier versions you can click on the cell that contains the error
and go to Tools>Formula Auditing>Trace error. I'm sure it's still
there in 2007, I just don't know where you would look for it.

Once you find it, that should shed some light on why you
are getting the error.

HTH
Martin
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Setting intercept to zero with SLOPE/STEYX/etc 3
Gradient and intercept on data with errors 2
"Slope" and "intercept" function help 4
Regression with zero intercept 2
intercept graph vs. function 2
Calculating slope, intercept, LOGEST with empty cells in data 1
Regression intercept to 0 2
Bug in SLOPE/INTERCEPT forumulas in Excel 2003 18

Top