#### TiTuS

##### Board Regular
Hi there,

We are trying to make a spreadsheet invoice that adds on a 3% charge to the total of our invoice for visa transactions.

The thing is when the 3% is taken off it needs to = the original total.

Tim

### Excel Facts

How to calculate loan payments in Excel?
Use the PMT function: =PMT(5%/12,60,-25000) is for a \$25,000 loan, 5% annual interest, 60 month loan.
Hi
if a1 has invoice number,
c1 = B1/1.03 return the original invoice value
I don't see where you are getting the problem
Ravi

Hi for some reason i dont quite agree with your answer but am not 100% sure why - what you say works yet if you take say \$1500 * 1.03

You have \$1545

Now if you times by .03 (this is to give you 3%)

Then minus that total from the \$1545 you are left with \$1498.65 not \$1500

I dont think it is quite as simple as you say but really appreciate your time!

To clarify i need to find how to find the number that when taking 3% off brings me back to my original number.

In practise this is what happens.

For each visa transaction we take in our business we get charged 3% for customers who want to use this facility we charge them the 3% so if the item retailed at \$1500 then we need to find what number we need to charge them so that when 3% is taken from it we are left with the original value of \$1500

Tim

3% of 1500 is 45
3% of 1545 is not 45.

You cannot add 3% to the ticket value (1500 + 45) and take 3% off the marked-up value (1545 - 46.35) and arrive at the same number.

Resolving this is a pricing issue, not a mathematical one.

Replies
4
Views
205
Replies
3
Views
375
Replies
8
Views
333
Replies
1
Views
90
Replies
1
Views
133

1,221,418
Messages
6,159,795
Members
451,589
Latest member
Harold14

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back