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
...