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?
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)
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...
My Recommended Reading:
Volatility
Sumproduct & Arrays
Pivot Intro
Email from XL - VBA & Outlook VBA
Function Dictionary & Function Translations
Dynamic Named Ranges
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks