-
In cell B4 in the Income sheet, create a formula that multiplies
Gross revenue per ream
times
Total reams sold in January
-
In cell B5, create a formula that multiplies
Net revenue per ream
times
Total reams sold in January
-
Edit the formulas in both cells to employ absolute references to the Gross revenue and Net revenue figures in the Per Ream Revenue sheet.
-
Fill the other cells in the worksheet to show the Gross and Net revenue for each month.