Add percentages to a workbook

[grahalex]

I have a work book of costs from Suppliers that I use at work, and I need to add percentage increases to it. Each Supplier has a different percentage. So for instance, on the chart below I need to add 5.13% to Bn, 2.28% to Do, 6.7% to Lo and 3% to Ni. Then I need to repeat this multiple times over the spreadsheet.

Bn Do Lo Ni
£400 £465 £367 £490
£400 £470 £421 £495
£400 £495 £404 £465
£180 £230 £184 £165
£550 £490 £488 £470
£295 £285 £256 £300
£145 £210 £135 £135
£180 £230 £229 £280
£295 £260 £271 £195

[AliGW]

Please add manually calculated sample results to the workbook and post it again to make it clear what you are aiming for.

[grahalex]

Sorry, I'm not sure what you mean. I have add more sections that need the percentages adding to if that helps.

[avk]

Not clear idea, if you enter required result (manually) in respective cell, its more helpful of both.

[grahalex]

I need to add 5.13% to every column that has the header Bn etc.

[AliGW]

No, you haven't clarified at all, sorry.

Please manually mock up the workbook to show the results you want to see - we need to see a before and after.

[avk]

For example BN. In "E3" 421, "I3" 442, "M3" 465 ... so on

[avk]

As per my assuming in "E3"

Please Login or Register  to view this content.

BN=5.13
Look attach file.

[José Augusto]

Hi

Try this in E3 and copy forward and down

Please Login or Register  to view this content.

[grahalex]

Hi, sorry if I haven't explained it very well. I have added a 2nd tab to the spreadsheet, so that one contains the base cost + the percentage.

[avk]

In inc percentage sheet "A3"

Please Login or Register  to view this content.

[grahalex]

Thanks for your replies. I Just need to apply one of these to my spreadsheet.

[AliGW]

Let us know how you get on.

[grahalex]

I will.

One thing though. Please can you explain how when bn is in the formulae it knows what percentage rate bn is. I am only a novice on excel.

[AliGW]

Go to the Formula ribbon and look at Named Ranges - AVK has set up one named range for each value.

[grahalex]

Oh yes, thanks.