work out  apercentage in excel 2003

Posted on 2011-11-01
Medium Priority
Last Modified: 2012-06-27
Hello experts

I am trying to work out how to make a formula that takes the value of one cell and gives me the total using the percentage value of another cell.

In my example:
G3 has a value of 1.39%
H3 has a value of £4166.67
I would like I3 to give me a value equal to 1.39% of £4166.67

Please help
Question by:wisemat
LVL 50

Accepted Solution

barry houdini earned 1000 total points
ID: 37063369
Just multiply the two, i.e. in I3


copy down

regards, barry
LVL 17

Assisted Solution

gtgloner earned 1000 total points
ID: 37063371
How about =G3*H3 in cell I3?

Author Comment

ID: 37063411
So obvious when you know how, points shared as were answered at same time, thank you both :)

Featured Post

Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

When you see single cell contains number and text, and you have to get any date out of it seems like cracking our heads.
How to get Spreadsheet Compare 2016 working with the 64 bit version of Office 2016
This Micro Tutorial will demonstrate how to use longer labels with horizontal bar charts instead of the vertical column chart.
Many functions in Excel can make decisions. The most simple of these is the IF function: it returns a value depending on whether a condition you describe is true or false. Once you get the hang of using the IF function, you will find it easier to us…

850 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question