I am currently working on a project for my college computer apps class focusing on Excel; there are a couple of instructions I am stumped on and any help is greatly appreciated!
The first one says:
In cell G5, insert a formula that will calculate what percentage of the total cost (in F10) was used by the Administration department (in F5). Ensure that the reference to the total cost is an absolute cell reference, and then copy the formula into the range G6:G9.
How would I write that above formula??
The second questions asks:
in Cell C32, insert a formula that will calculate the projected operations cost after the forecasted increase in cell B30 is added to the 2016 total (in B32). Ensure that the reference to cell B30 is an absolute cell reference, and then copy the formula into the range D32:F32.
Thanks!
Answers & Comments
Verified answer
G5=$F5/$F$10 format as % copy down to G9
C32 =$B$30+B$32 copy across to F32
G5=$F5/$F$10 format as % copy down to G9
C32 =$B$30+B$32 copy across to F32
To make a cell reference (or part of a reference) absolute you must put a $ sign in front of the bit you don't want to change as the reference is filled down/up or across. ie if you did not put the $ and filled down the reference to cell A1 it would become cell B2, C3, D4 etc. If you make the reference absolute ($A$1) it will not change if you move it. ie it will always refer to cell A1