do you know how to write the formula in EXCEL to add a fixed number (numA1) to another number (B1), and then add the result (C1) with A1....and then add the result to the fixed number
A1B1C1D1E1F1
332353841.. .. ..
without type B1 + A1 in C1, C1 + A1 in D1, D1 + A1 in E1....etc
Excel Formula
2008-05-31 8:43 pm
回答 (2)
2008-06-01 8:36 am
✔ 最佳答案
In C1, type B1 + $A$1.Then, copy C1 to D1, E1, F1 ... ....
$A$1 will remain unchange. B1 will automatically change to C1, D1, E1 correspondingly after copying.
收錄日期: 2021-04-20 11:48:11
原文連結 [永久失效]:
https://hk.answers.yahoo.com/question/index?qid=20080531000051KK01050