ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   how do i find the slope of a line in excel? (https://www.excelbanter.com/excel-discussion-misc-queries/159443-how-do-i-find-slope-line-excel.html)

colin mccready

how do i find the slope of a line in excel?
 


JE McGimpsey

how do i find the slope of a line in excel?
 
What are you starting with?

If you have two points, say, (x1,y1) in A1:B1 and (x2,y2) in A2:B2 then
the slope in C1 is returned by

C1: =(B2-B1)/(A2-A1)

In article ,
colin mccready <colin wrote:

Bernard Liengme

how do i find the slope of a line in excel?
 
1) By making an XY chart and inserting a trendline with the equation
displayed
or
2) By using the SLOPE function

Have you experimented using Excel's Help feature - it is very useful
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
www.stfx.ca/people/bliengme
remove caps from email

"colin mccready" <colin wrote in message
...




Bob I

how do i find the slope of a line in excel?
 
See Help, Slope.

colin mccready wrote:


David Biddulph[_2_]

how do i find the slope of a line in excel?
 
Firstly, the purpose of the message body is to allow you to ask the
question. Don't just put it in the subject line. Blank messages are often
rejected or ignored.

Secondly, why not be brave and type the word "slope" into excel help and see
what you find? [A more blunt answer would be RTFM]
--
David Biddulph

"colin mccready" <colin wrote in message
...





All times are GMT +1. The time now is 07:53 PM.

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