Please Help with percentages!!

cashman

New Member
Joined
Oct 1, 2011
Messages
2
I need big help guys, there are two data sets, first with numbers and second in percents. If somebody could please tell me how can i automatically calculate and autofill the percentages from the first set into second , does somebody know the way or formula?
Big tnx in advance

i would post the excel file but there isnt attach option
 

Excel Facts

Get help while writing formula
Click the italics "fx" icon to the left of the formula bar to open the Functions Arguments dialog. Help is displayed for each argument.
Hi and Welcome on board,

Let us have a simple example, what is the input data (choose a column where the data is stored) and what would be the result you would like to achieve. Thank you.
 
Upvote 0
Welcome to the Board!

See the link beneath my sig for how to post a screen shot.

P.S. I'm deleting your other duplicate post.
 
Upvote 0
Sorry, you'll find that most people are either blocked from file sharing sites, or simply won't download something from an untrusted source. In addition, a .jpg means a static image that someone will have to go recreate in Excel on their own time, and this is a volunteer forum.

The link I mentioned will let you post an actual HTML image of your spreadsheet, which someone can then copy into Excel and work on. You'll get far more responses that way.
 
Upvote 0

Forum statistics

Threads
1,224,514
Messages
6,179,220
Members
452,895
Latest member
BILLING GUY

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