␡
- name the sheet
- understand references
- enter information
- activate a cell
- enter row headings
- enter column headings
- make a column wider
- enter values
- calculate a difference
- calculate a percent diff
- sum some values
- calculate net income
- copy formulas
- copy and paste
- use the fill handle
- change a value
- extra bits
This chapter is from the book
calculate a percent diff
Column E calculates the percent difference between the budgeted and actual amounts. The percentage is based on the budgeted amount. We'll write the first formula now and copy it to other cells in column E later.
Its cell reference appears in cell E3.
Its cell reference is appended to the formula in cell E3.
Press Enter (Windows) or Return (Mac OS).
The result of the formula you entered appears in cell E3.