# Need help with percentage calculations

#### Marianb

##### New Member
Hello everyone

i am a real novice with excel and have been asked to set up a spreadsheet to show what percentages of a starting figure is being spent on materials, labour and then what the final figure remaining is as a percentage

example

starting amount £5000.00 minus £1250.00 materials, what percentage is being spent on materials.
Then labour £2300.00, what percentage of the £5000.00 is this
finally the overall percentage earned after the labour charge and material charges have been deducted from the £5000.00

i really hope someone can help as I really have no idea how to do this

### Excel Facts

Did you know Excel offers Filter by Selection?
Add the AutoFilter icon to the Quick Access Toolbar. Select a cell containing Apple, click AutoFilter, and you will get all rows with Apple
Hi, and welcome to the forum. See below:

Excel 2007
ABC
1£%
2Starting Amount£5,000.00
3Materials£1,250.0025.0%
4Labour£2,300.0046.0%
5Earned£1,450.0029.0%
Sheet1
Cell Formulas
RangeFormula
C3=B3/\$B\$2
C4=B4/\$B\$2
C5=B5/\$B\$2
B5=B2-B3-B4

ps Highlight the ranges, right click and select format.
In the example above cells, B2:B5 format as currency
C3:C5 format as percentage

Thanks for that Bertie, I pretty much understand what you've said with the exception of everything after the /sign in C3 C4 and C5. I will have my column B formatted with £ currency but what is the \$2 meaning

Cell B2 contains the starting amount.
If we just used B2 in the formula then when we "drag" or "copy and paste" the formula then B2 would change to B3, B4 etc

To prevent the reference to B2 from changing we enter it as an "absolute" reference, i.e., wrap dollar signs around it.

\$B\$2 is an "absolute" reference to the cell.
This means we can enter the formula in cell C3, and drag the formula over C3, C4 and C5, (or copy and paste the formula) and the absolute reference to \$B\$2 doesn't change.

See the Excel help file for Absolute Reference

Thanks again Bertie. I'm going to read about "absolute reference" told you I was a novice lol
can I just clarify, as I'm in the uk will the dollar sign be replaced with the £ sign

I've done it and now understand a lot more a big thank you Bertie. And I even learnt about using f4 instead of typing in the \$ signs.

Replies
0
Views
304
Replies
10
Views
2K
Replies
3
Views
5K
Replies
1
Views
1K
Replies
3
Views
551

1,196,368
Messages
6,014,877
Members
441,853
Latest member
Carlp16

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back