View Single Post
  #7  
Old 17-04-2011, 11:07 AM
mithrandir's Avatar
mithrandir (Andrew)
Registered User

mithrandir is offline
 
Join Date: Jan 2009
Location: Glenhaven
Posts: 4,161
Quote:
Originally Posted by kinetic View Post
Just a slight correction to Andrew's formula above:
In E3 put =SLOPE(B3:B122,A3:A122)
In E4 put =INTERCEPT(B3:B122,A3:A122)


Commas as separators ^
That's a lack of standards thing.

Excel uses ",". OpenOffice uses ";".
Reply With Quote