writer
5,435
edits
Changes
Jump to navigation
Jump to search
Line 21:
Line 21: − DATA1 DATA2 − 4 12 − 5 20 − 2 15 − 10 11 − − INTERCEPT(B5:B8,C5:C8)=10.13265306 − − DATA1 DATA2 − 25 10 − -12 15 − -9 -40 − 30 52 − 18 36 − − INTERCEPT(A2:A6,B2:B6)=4.754939085 − − Line 59:
Line 41: + + +
Manuals/calci/INTERCEPT (view source)
Revision as of 08:44, 31 December 2013
, 08:44, 31 December 2013→Examples
==Examples==
==Examples==
{| class="wikitable"
{| class="wikitable"
|+Spreadsheet
|+Spreadsheet
| || || || ||
| || || || ||
|}
|}
#=INTERCEPT(A1:D1,A2:D2)= 10.13265306
#=INTERCEPT(A3:E3,A4:E4)= 4.754939085