• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

find swipe charges

Hello guys

I want to find the swiped amount from the actual amount. kindly help

Swipe Amount₹ 38,842.00
Charges 1.99%₹ 772.96
GST 18%₹ 139.13
Charges+GST₹ 912.09
Actual Amount₹ 37,929.91
 
Sorry i mean calculation is tough to understand. But buddy thanks a lot to help me in this calculation. Now i m reading the calculation format. Thanks a lot for the fast help
 
The calculation you showed is
actualAmount = swipeAmount - (swipeAmount*chargeRate) - (swipeAmount*chargeRate*rateGST)
Hence
swipeAmount = actualAmount / (1 - chargeRate * (1 + rateGST))
 

Attachments

  • New Microsoft Excel Worksheet (45).xlsx
    13 KB · Views: 4
Last edited:
Back
Top