ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   intercept and slope functions (https://www.excelbanter.com/excel-worksheet-functions/186592-intercept-slope-functions.html)

midbond

intercept and slope functions
 
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

MartinW

intercept and slope functions
 
Hi midbond,

In earlier versions you can click on the cell that contains the error
and go to ToolsFormula AuditingTrace 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


"midbond" wrote:

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



All times are GMT +1. The time now is 09:14 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com