How does one get "X" in excel from the formula 100=X-(X*21%)-(X*2.7%) ?
Background: Credit cards take a percentage of the VAT inclusive amount. I would like this credit card cost to be automatically included in total VAT inclusive cost.
For example, VAT is 21% and credit card fee is 2.7% on the total VAT inclusive amount. A theoretical VAT inclusive amount of 121 would have a credit card cost of 3.267 and a VAT cost of 21, so the net amount is not 100 but 96.733
What would the VAT inclusive amount need to be to have a net amount of 100? And how does one put this in an excel formula?
Bookmarks