+ Reply to Thread
Results 1 to 4 of 4

Formula to give me an amount from a percentage

  1. #1
    Registered User
    Join Date
    05-20-2015
    Location
    London
    MS-Off Ver
    2007
    Posts
    2

    Formula to give me an amount from a percentage

    Hi Everyone

    Hopefully this will be a straightforward one that someone is able to assist with.

    Basically I have a column of figures and a column of percentages, and what I want to do is incorporate a formula so when I add in the percentage the next column brings back what that actual amount would equate to - Please see the below example.

    A1: 2,000
    B1: 10%
    C1: =200

    I appreciate it would be a lot easier the other way around, to have the 2 figures and to give me a percentage each time, but I am needing to include this on a sheet that I have been working on for some time so it would be a great deal of manual work to change.

    Thanks in advance for any help

    Regards

    James

  2. #2
    Forum Expert
    Join Date
    09-11-2014
    Location
    Washington, DC
    MS-Off Ver
    2016
    Posts
    1,907

    Re: Formula to give me an amount from a percentage

    Assuming column B is formatted as an actual percentage, C1 would just be =A1*B1
    Spread the love, add to the Rep

    "None of us are as smart as all of us."

  3. #3
    Registered User
    Join Date
    05-20-2015
    Location
    London
    MS-Off Ver
    2007
    Posts
    2

    Re: Formula to give me an amount from a percentage

    felt a bit stupid asking, I knew it would be something easy

    Thanks for help, much appreciated

  4. #4
    Forum Expert
    Join Date
    09-11-2014
    Location
    Washington, DC
    MS-Off Ver
    2016
    Posts
    1,907

    Re: Formula to give me an amount from a percentage

    No worries, gotta start somewhere. If this answers your question, please consider marking the thread as SOLVED using the thread tools.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Need help - Formula to Find and give the total amount of Text.
    By Poashap in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 07-25-2014, 01:09 PM
  2. Formula to check for name and give a percentage
    By BaiL in forum Excel Formulas & Functions
    Replies: 10
    Last Post: 11-06-2013, 04:06 AM
  3. [SOLVED] Formula to check the value and give me percentage (+/-)
    By hecgroups in forum Excel Formulas & Functions
    Replies: 10
    Last Post: 04-01-2013, 12:50 PM
  4. Replies: 2
    Last Post: 09-14-2012, 12:45 PM
  5. [SOLVED] Formula to give An amount with 10% adding
    By tariqnaz2005 in forum Excel General
    Replies: 5
    Last Post: 05-30-2012, 04:48 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1