Getting a total number from a percentage.

Jon1995

New Member
Joined
Apr 16, 2020
Messages
10
Office Version
  1. 365
Platform
  1. Windows
Hi all,

I have attached a screenshot of what I want to do. Essentially, I want to populate Column G with numbers which relate to percentages in Column J, they are percentages of the number displayed in cell G28. I found this hard to explain so if you need any more information, please let me know.

Thanks
Jon
 

Attachments

  • 1587060178201.png
    1587060178201.png
    60.8 KB · Views: 13

Excel Facts

How can you automate Excel?
Press Alt+F11 from Windows Excel to open the Visual Basic for Applications (VBA) editor.
=$G$28*J9
with give you 20% of 265

copy down to the other rows G17 & G26

is that what you meant ?
 
Upvote 0

Forum statistics

Threads
1,215,446
Messages
6,124,904
Members
449,194
Latest member
JayEggleton

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