work out  apercentage in excel 2003

Posted on 2011-11-01
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

    Just multiply the two, i.e. in I3


    copy down

    regards, barry
    LVL 17

    Assisted Solution

    How about =G3*H3 in cell I3?

    Author Comment

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

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    What Security Threats Are You Missing?

    Enhance your security with threat intelligence from the web. Get trending threat insights on hackers, exploits, and suspicious IP addresses delivered to your inbox with our free Cyber Daily.

    A little background as to how I came to I design this code: Around 5 years ago I designed an add-in that formatted Excel files to a corporate standard, applying different cell colours and font type depending on whether the cells contained inputs,…
    Introduction This Article is a follow-up to my Mappit! Addin Article (, it was inspired by an email posting I made to EUSPRIG (, I will briefly cover: 1) An overvie…
    This Micro Tutorial will demonstrate how to use longer labels with horizontal bar charts instead of the vertical column chart.
    This Micro Tutorial demonstrates in Microsoft Excel how to consolidate your marketing data by creating an interactive charts using form controls. This creates cool drop-downs for viewers of your chart to choose from.

    759 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

    Need Help in Real-Time?

    Connect with top rated Experts

    7 Experts available now in Live!

    Get 1:1 Help Now