# Formula to find the base amount [Closed]

Carlo1991 - Dec 3, 2017 at 05:40 PM - Latest reply: Ambucias 47882 Posts Monday February 1, 2010Registration dateModeratorStatus December 17, 2017 Last seen - Dec 3, 2017 at 05:56 PM
Excel
Hello,

I have new taxation laws that apply my organization from January.

The current taxes are 10% +10%
So if it was 100 it came upto 120

Now they have introduced one more variable. It is 10% + 10% + (another 5% on base with one 10%)

so 100 + 10 + 10 +( 110*5%) =125.5

I know how to set up the formula to calculate the tax. But how do I get the base amount if I have the amount with taxes?

For example, How do I set up a formula to find 100 if I know the total amount is 125.5?

See more

Ambucias 47882 Posts Monday February 1, 2010Registration dateModeratorStatus December 17, 2017 Last seen -
0
Greetings,

Please, bare in mind that CCM is a mutual aid community, all answers on the forum are provided by volunteers who give their time free to help solve issues.

Hence we request that CCM forum users show mutual respect. Therefore, when asking for assistance, please be courteous, as for elsewhere in similar circumstances in every day society when asking for help. (Usually, how would someone ask for help? i.e. please, thank you, appreciate, grateful, etc.)

Being courteous will increase your chances of getting the help you need.

http://ccm.net/contents/948-terms-of-use-for-ccm-respect-for-others

Please, copy, modify and repost your message respecting the politeness charter.

We trust that you understand.

Moderator