Hi,
can anyone tell me how i can make a formula to minus ie: -11% in one cell from a whole number in another to get the result?
thanks
legepe
Hi,
can anyone tell me how i can make a formula to minus ie: -11% in one cell from a whole number in another to get the result?
thanks
legepe
You could multiply by the remaining percentage
=A1*0.89
Or
=A1-A1*0.11
Hope that helps.
RoyUK
--------
For Excel Tips & Solutions, free examples and tutorials why not check out my web site
Free DataBaseForm example
TIP OF THE DAY:
If you're going to multiply percentages, you should definitely round the result to "lock" the value at something meaningful and consistent to you. Otherwise, the answers you see in the cell may not match the long decimal result that is actually in the cell, and summing a bunch of those cells creates problems.
For example:
Notice the results of each row in B and C appear to be the same all the way down, but when you SUM the results at the bottom, the column B answer is wrong. This is what happens when you SUM long-decimal values without proper rounding enforced.Please Login or Register to view this content.
_________________
Microsoft MVP 2010 - Excel
Visit: Jerry Beaucaire's Excel Files & Macros
If you've been given good help, use the icon below to give reputation feedback, it is appreciated.
Always put your code between code tags. [CODE] your code here [/CODE]
?None of us is as good as all of us? - Ray Kroc
?Actually, I *am* a rocket scientist.? - JB (little ones count!)
or :
=A1*(100%-11%)
I prefer to use the % sign rather than decimals, and putting it in this form I have found is easier understood when referring to general texts on percentages!
Regards
Darren
Update 12-Nov-2010 Still job hunting!
If you are happy with the results, please add to our reputation by clicking the blue scales icon in the blue bar of the post.
Learn something new each day, Embrace change do not fear it, evolve and do not become extinct!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks