X hits on this document

284 views

0 shares

0 downloads

0 comments

27 / 65

Enter formulas

Update formula results

As the picture shows, when the value in cell C4 changes, Excel automatically updates the February total in cell C7 from 126.93 to 130.92.

Excel can do this because the original formula =SUM(C3:C6) in cell C7 contains cell references.

If you had entered 11.97 and other specific values into a formula in cell C7, Excel would not be able to update the total. You’d have to change 11.97 to 15.96 not only in cell C4, but in the formula in cell C7 as well.

Document info
Document views284
Page views284
Page last viewedSat Dec 10 08:00:31 UTC 2016
Pages65
Paragraphs433
Words3509

Comments