+ Reply to Thread
Results 1 to 4 of 4

A formula which will work out a Fee from a payment - based on a capped & collared structu

  1. #1
    Registered User
    Join Date
    01-21-2013
    Location
    Cheshire
    MS-Off Ver
    Excel 2003
    Posts
    18

    A formula which will work out a Fee from a payment - based on a capped & collared structu

    I want a formula that will provide the answer 16.9% of a value or £34.50, whichever is the greater, but never greater than £90. Is this possible - so if the value is £150 the answer is £34.50, if the value is £300 the answer is £50.70, if the value is £800 the answer is £90.

    This is to automatically work out a clients fee from their payment - fee structure is 16.9%, but with a minimum of £34.50 - maximum of £90

  2. #2
    Forum Moderator jeffreybrown's Avatar
    Join Date
    02-19-2009
    Location
    Cibolo, TX
    MS-Off Ver
    Office 365
    Posts
    10,316

    Re: A formula which will work out a Fee from a payment - based on a capped & collared stru

    Maybe one option...

    =IF(A1*G1<34.5,34.5,IF(A1*G1>90,90,A1*G1))

    A1 = Value
    G1 = 16.9%
    HTH
    Regards, Jeff

  3. #3
    Registered User
    Join Date
    01-21-2013
    Location
    Cheshire
    MS-Off Ver
    Excel 2003
    Posts
    18

    Re: A formula which will work out a Fee from a payment - based on a capped & collared stru

    Perfect - Many thanks

  4. #4
    Forum Moderator jeffreybrown's Avatar
    Join Date
    02-19-2009
    Location
    Cibolo, TX
    MS-Off Ver
    Office 365
    Posts
    10,316

    Re: A formula which will work out a Fee from a payment - based on a capped & collared stru

    You're welcome…glad it worked out for you and thanks for the feedback...

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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