+ Reply to Thread
Results 1 to 4 of 4

Payment fee calculation

  1. #1
    Registered User
    Join Date
    10-14-2018
    Location
    Toronto
    MS-Off Ver
    2016 pro
    Posts
    5

    Payment fee calculation

    Hello,

    I need some help on creating a formula to calculate my payments fee.
    I currently get paid by debit and credit cards but adding up email transfer.
    All of them have different fee rate.
    Debit is 10c on each transaction
    Email transfer is 50c on each transaction
    Credit cards have two different rates, 2.65% and 2.75%.

    Someone helped me in this forum before to calculate debit and credit cards, but I have no idea how to add this email transfer into current formula.
    If anyone could change my current formula or give me something different which works better, I'd appreciate it very much. I attached my excel sheet.
    Thank you for time and help in advance.

    Kihun
    Attached Files Attached Files

  2. #2
    Forum Expert
    Join Date
    11-27-2007
    Location
    New Jersey, USA
    MS-Off Ver
    2013
    Posts
    1,669

    Re: Payment fee calculation

    Formula in R5: drag it up and down the column.

    HTML Code: 
    1. Click on the * Add Reputation if you think this helped you
    2. Mark your thread as SOLVED when question is resolved

    Modytrane

  3. #3
    Registered User
    Join Date
    10-14-2018
    Location
    Toronto
    MS-Off Ver
    2016 pro
    Posts
    5

    Re: Payment fee calculation

    Thank you!
    It works perfectly!

  4. #4
    Forum Expert
    Join Date
    11-27-2007
    Location
    New Jersey, USA
    MS-Off Ver
    2013
    Posts
    1,669

    Re: Payment fee calculation

    Glad, it worked for you.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Payment calculation
    By DimitraBoz in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 02-07-2018, 08:57 AM
  2. Replies: 5
    Last Post: 03-07-2017, 02:52 AM
  3. Payment Calculation with 90 day deferred first payment
    By MSE7 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 09-09-2015, 07:56 PM
  4. Calculation/payment of Acquistion Bonus
    By jerplus in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 04-09-2013, 08:55 PM
  5. Lease Payment Calculation
    By mikemack79 in forum Excel General
    Replies: 1
    Last Post: 02-16-2010, 11:05 PM
  6. Calculation Of Last Payment Made
    By kanwal_deep in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 05-19-2007, 06:43 AM
  7. [SOLVED] payment calculation
    By in forum Excel General
    Replies: 3
    Last Post: 11-17-2005, 01:40 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1