Need help with percentage calculations

Marianb

New Member
Joined
Sep 22, 2014
Messages
4
Hello everyone

can anyone help please.
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

When did Power Query debut in Excel?
Although it was an add-in in Excel 2010 & Excel 2013, Power Query became a part of Excel in 2016, in Data, Get & Transform Data.
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
 
Upvote 0
ps Highlight the ranges, right click and select format.
In the example above cells, B2:B5 format as currency
C3:C5 format as percentage
 
Upvote 0
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
 
Upvote 0
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
 
Upvote 0
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
 
Upvote 0
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.
 
Upvote 0

Forum statistics

Threads
1,213,532
Messages
6,114,176
Members
448,554
Latest member
Gleisner2

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.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

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

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

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
Back
Top