hi excelers,
sounds simply but how does one subtract a percent from a value?
example:
50%-100 = 50
30%-30 = 10
etc
star for the first solution *_*
hi excelers,
sounds simply but how does one subtract a percent from a value?
example:
50%-100 = 50
30%-30 = 10
etc
star for the first solution *_*
I don't understand. How is 50%-100 = 50 or 30%-30 = 10?
Also your tile asks how to subtract a percent from a value but these two samples are subtracting a value from a percent.
Your examples look like:
50% of 100 = 50
30% of 30 = 10
although the second one is not quite right (should be 33.3% of 30 = 10).
If this is correct, then the of is equivalent to multiply, not subtract.
Hope this helps.
Pete
thx Pete, sorry for the errors...but you both are right
but what would be the formula should it be
=50%*100
Try that out and see.
Pete
If however you mean that you want to substract 30% from 10 then you would need to multiply by the inverse ie x 70% or calculate the 30% and then deduct it eg
Please Login or Register to view this content.
If someone has helped you then please add to their Reputation
Pete, how do I subtract 10% from 100% = 90%
Try this:
=100%-10%
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
Forum Rules (updated August 2023): please read them here.
=1-0.1
or
=100%-10%
Edit: Thanks for the rep!
Last edited by 63falcondude; 10-15-2018 at 09:06 AM. Reason: Rep Added
Try this:
=!00% - 10%
Of course, you could have those values in two cells, where A1 ==> 100%, and B1 ==> 10%, then you could do:
=A1-B1
Hope this helps.
Pete
Forgive me for pointing this out!
The solutions we are offering are very basic: just a little bit of trial and error on your part in an Excel workbook would answer most of these things without recourse to the forums. We are more than happy to help you, of course, but remember that your workbook will not self-destruct if you try a few things for yourself. That's how some of us have learnt.
here is some extra details which I am trying to do.
sorry I find it hard to explain so here is three examples:
10% - 100% = 90%
30% - 90% = 60%
50% - 50% = 25%
These are not mathematically correct, so you are going to have to explain in words what your logic is.
I will try:
I am trying to subtract a percent from a other percent if that is possible?
bit like slicing a cake into smaller bits...the second percent values is always sees as a values not percent, so for example if I ask what is 50%- 50%= ? I am really saying what is 50% - 50 = 25
But that's not 50%-50%, is it?
Try this:
=50-50%
If you want any further help, remove the solved tag.
ok I marked this thread as unsolved!
what is 50% of 50% I sad its 25% is there a forumla for that or is it impossible to calculate?
Last edited by QuantEdge; 10-15-2018 at 12:49 PM.
I said earlier that of is equivalent to multiply, so do this:
=50% * 50%
Hope this helps.
Pete
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks