Sub SLOPEcal start the slope function scope. We then write the slope as a fraction. The slope calculation formula is given by-Slope RiseRun.
Let us study What is the slope formula.
Step 2 To turn the equation into slope-intercept form divide both the sides by 5 such that we get y -25x1. Suppose we have the Xs values located in the excel sheet range from A1 to A10 and Ys values located in the given excel sheet from range B1 to B10 then we can calculate the SLOPE here by using the below VBA functions. Comment on Kim Seidels post You can find the slope using 2 points and the slop. Since 1 and -1 are opposites and reciprocals of each other segments AC and BC are perpendicular to each other so triangle ABC is a right triangle.