+ Reply to Thread
Results 1 to 2 of 2

Multiply a certain percentage in Excel

  1. #1
    Registered User
    Join Date
    06-07-2007
    Posts
    1

    Multiply a certain percentage in Excel

    Guys, I need to do something which is probably very simple for you.

    I have a spreadsheet I'm making for someone but I suck at math although it's probably very simple.

    I have one field where I want to enter a value in % and then I want to multiply that with the total of a bunch of other fields but not sure how to express it.

    I tried this =(D47+D44) where D47 is the total of the other fields and D44 is the field formatted as PERCENTAGE but all it adds is .02 to the end of my total (if I entered 2% that is).

    Also, what I do now is make a field first where it calculates the TOTAL of 4 fields and THEN add another field for the total times the percentage simply because I don't know how to do this all in one field.

    Any help?

    Thanks

    George

  2. #2
    Forum Expert Paul's Avatar
    Join Date
    02-05-2007
    Location
    Wisconsin
    MS-Off Ver
    2016/365
    Posts
    6,885
    I would think you could use this:

    =D47+(D47*D44)

    If D47 was 100, and D44 was .02, this would result in:
    =100+(100*.02)
    =100+(2)
    =102

    If you wanted to save a step (and do it in one cell like you said), instead of putting your sum in D47, you could use something like:
    =SUM(D40,D42,E14,F21)+(SUM(D40,D42,E14,F21)*D44)

    where D44 holds your percentage. If you didn't want to store the percentage anywhere, you could just replace D44 with .02
    Last edited by Paul; 06-07-2007 at 09:51 PM.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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