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.
Activate cell E3.
Type =.
Click in cell D3.
Its cell reference appears in cell E3.
Type /.
Click in cell ...
Get Creating Spreadsheets and Charts in Excel: Visual QuickProject Guide now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
