View Categories

How do I use the INTERCEPT or SLOPE function in Excel?

< 1 min read

Follow these steps to use the INTERCEPT or SLOPE functions in Exccel:


  1. Open the Excel spreadsheet that contains the data you want to use to calculate the slope or intercept.
  2. Enter the ‘Slope’ or ‘Intercept’ function in the formula bar followed by the data range for both variables.
  3. Select the entire range that contains your data.
  4. Press ‘Enter’ to calculate the slope or the intercept.

Powered by BetterDocs