Solved

# work out  apercentage in excel 2003

Posted on 2011-11-01
Medium Priority
221 Views
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

Resource-calculator-v1.xls
0
Question by:wisemat

LVL 50

Accepted Solution

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

=G3*H3

copy down

regards, barry
0

LVL 17

Assisted Solution

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

Author Comment

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

## Featured Post

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…
###### Suggested Courses
Course of the Month15 days, 20 hours left to enroll