| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Setting intercept to zero with SLOPE/STEYX/etc | Excel Worksheet Functions | |||
| how to get slope with a forced intercept of zero | Excel Worksheet Functions | |||
| Linear Regression by set Slope (not intercept) | Excel Discussion (Misc queries) | |||
| Excel Linear Regression by set slope (not intercept) | Excel Worksheet Functions | |||
| plot 10 data pts in least square fit to find slope and intercept | Excel Worksheet Functions | |||
Linear Mode
