Calculate a Difference p. 33
In Excel, all formulas begin with an equals sign (=).
Although you can write a formula that subtracts one number from another, using cell references in the formula ensures that the formula's results remain correct, even if referenced cells' values change.
As our formula is written, if the actual amount is lower than the budgeted amount, the difference appears as a negative number. You can make this appear as a positive number by switching the order of the cell references so the formula is =B3-C3.
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.