更新1:
ButI don't know why I can't highlight both cells C1 and D1
urgent,maths in excel,help pl
2009-08-15 8:56 pm
Use excel to evaluate 5X^3 + 13X^2 - 7X + 44 from x = -10, to x = 10 . Do this in columns C and D
回答 (2)
2009-08-17 6:14 am
✔ 最佳答案
如要每下拉一格, 值加一, Excel是用ROW函數任何一格, 輸入 =ROW(A1) ←傳值為 1
下拉一格, 公式會變成 =ROW(A2)←傳值為 2, 如此類推
如輸入 =ROW(A1)-11←傳值為 -10
下拉一格, 公式會變成 =ROW(A2)-11←傳值為 -9
解此題方法:
將 (ROW(A1)-11) 取代公式內所有的X便可以
即在任何一格(假設在C2)輸入公式:
=5*(ROW(A1)-11)^3+13*(ROW(A1)-11)^2-7*(ROW(A1)-11)+44
然後將C2公式下拉至C22, 即共21格
C3的X值是 -9
C4的X值是 -8, 依此類推, C22 的 X值便是 10
2009-08-15 10:14 pm
Firstly, type in the formula for 5X^3 + 13X^2 - 7X + 44, which is =5*D1*D1*D1+13*D1*D1-7*D1+44, in cell C1.
Next, input -10 in D1.
Then, hold the left click of the mouse to highlight cells C1 and D1.
After that, move your mouse to the right bottom corner of the cell D1 until your mouse cursor becomes a BLACK CROSS.
Finally, drag it down from cell D1 to D21. (make sure you have highlighted both cells C1 and D1 before you drag it)
Now you can evaluate the above formula from x=-10 to 10.
Next, input -10 in D1.
Then, hold the left click of the mouse to highlight cells C1 and D1.
After that, move your mouse to the right bottom corner of the cell D1 until your mouse cursor becomes a BLACK CROSS.
Finally, drag it down from cell D1 to D21. (make sure you have highlighted both cells C1 and D1 before you drag it)
Now you can evaluate the above formula from x=-10 to 10.
收錄日期: 2021-04-23 19:00:36
原文連結 [永久失效]:
https://hk.answers.yahoo.com/question/index?qid=20090815000051KK00758