+ Reply to Thread
Results 1 to 3 of 3

Percentage formulas?

  1. #1
    Forum Contributor
    Join Date
    10-16-2009
    Location
    England
    MS-Off Ver
    Excel 2007
    Posts
    257

    Percentage formulas?

    Im using excel 2007, Ive created a table for a game I play which adds up totals etc, but what i'm not sure how / if it can be done is take a percentage away from a total figure??? but i want it so:

    If the totals in the tables add up to say 100 i want to be able to put a box in which for example would have number 1 in, and if this box has number 1 then the tables would subtract 4% from the totals, but if it has a figure of nothing or 0 then it would do the standard calculations.

    Is this possible?

  2. #2
    Forum Contributor mewingkitty's Avatar
    Join Date
    09-29-2008
    Location
    Fort McMurray, Alberta, Canada
    MS-Off Ver
    Excel 2003
    Posts
    949

    Re: Percentage formulas?

    Anything is possible.
    Excel can make your car fly.

    K, maybe not really...

    Anyways... an example would be very helpful.

    It sounds like you'd need nothing more than to have a cell which references your original number, and has it (say it's A1) and your "possible variable subtracted" in another cell (say it's C1), and have your table base its value on a cell who's value is A1-C1... or A1*(1-C1) if C1 is the % to be deducted. Or A1*(1-(C1/100)) if C1 is a whole number and not a % per se.

    Without seeing more of what you're working on that's all I can really throw at you for now. Let me know!

    mew!
    =IF(AND(OR(BLONDE,BRUNETTE,REDHEAD),OR(MY PLACE,HER PLACE),ME),BOW-CHICKA-BOW-WOW,ANOTHER NIGHT ON THE INTERNET)

  3. #3
    Forum Guru DonkeyOte's Avatar
    Join Date
    10-22-2008
    Location
    Northumberland, UK
    MS-Off Ver
    O365
    Posts
    21,531

    Re: Percentage formulas?

    Agreed, example files speak a thousand posts.

    Based on your narrative - in logic terms ...

    =(1-(4%*criteriacell))*SUM(valuesrange)

    where criteria cell contains the 0/1 flag and values range your range that totals 100 etc...

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Tags for this Thread

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