You could put together a spreadsheet like the one below, with the list of items to be purchased, their unit prices, the number of each item ordered, and the total spent for each. Let's say you were putting together an office supply order, and you wanted to keep track of much you were spending. If you change E5 to 7, the result will automatically change to 18. (Note: all formulas in Excel need to be preceded by an “=” sign.) If the values contained in E5 and E6 are 6 and 11, respectively, the formula will produce 17 as the value it displays. For example, a formula that adds the contents of cell E5 and E6 could be written as follows: Formulas in Excel are basically mathematical expressions that use cell references (e.g., “A5”,” D17”) as arguments.
0 Comments
Leave a Reply. |