+ Reply to Thread
Results 1 to 6 of 6

Formula required for a fixed fee amount

  1. 08-16-2017, 11:07 PM #1
    cool_eyes99
    cool_eyes99 is offline
    Registered User
    Join Date
    08-16-2017
    Location
    Australia
    MS-Off Ver
    2010
    Posts
    7

    Unhappy Formula required for a fixed fee amount

    Hi,
    Can some advise what the Excel formula is used for the following calculation for Excel 2010.

    I need to calculate a total fixed Fee from a net figure that includes a 3% fee on the net figure for a total of 1,000 with tax on both. The answer is 882.61 from a manual calculation but need to create a table in Excel.

    To be clear it is made up of the following:

    Fee - $882.61 - plus 10% Tax = 970.87
    3% charge - $26.48 - plus 10% Tax = 29.13
    Total $1,000.00

    Basically need to work back and find out what the Net Fee is and on this example is on a total of 1,000 but will need to work on 1,500 / 2,000 / 2,500 and so on.

    Please help!
    Cheer
    Reply With QuoteRegister To Reply
  2. 08-16-2017, 11:22 PM #2
    leelnich
    leelnich is offline
    Forum Expert leelnich's Avatar
    Join Date
    03-20-2017
    Location
    Delaware, USA
    MS-Off Ver
    Office 2016
    Posts
    2,807

    Re: Formula required for a fixed fee amount

    Hi Cool- If total is in cell A2, this calculates the "882.61" part:

    =A2/1.1/1.03

    Please click the Add Reputation star below any helpful posts, and use Thread Tools (up top) to mark your thread as SOLVED once you have your answer. Thanks!-Lee
    Last edited by leelnich; 08-16-2017 at 11:25 PM.
    Reply With QuoteRegister To Reply
  3. 08-17-2017, 02:21 AM #3
    FlameRetired
    FlameRetired is offline
    Forum Moderator
    Join Date
    01-21-2014
    Location
    St. Joseph, Illinois U.S.A.
    MS-Off Ver
    Office 365 v 2403
    Posts
    13,406

    Re: Formula required for a fixed fee amount

    Not sure I have interpreted correctly. With initial numbers in column A try this formula.
    Formula: copy to clipboard 
    Please Login or Register  to view this content.



    A
    B
    1
    2
    882.61
    1000
    3
    26.48
    4
    Dave
    Reply With QuoteRegister To Reply
  4. 08-17-2017, 02:27 AM #4
    cool_eyes99
    cool_eyes99 is offline
    Registered User
    Join Date
    08-16-2017
    Location
    Australia
    MS-Off Ver
    2010
    Posts
    7

    Re: Formula required for a fixed fee amount

    Awesome thanks very much works great!
    Reply With QuoteRegister To Reply
  5. 08-17-2017, 02:28 AM #5
    FlameRetired
    FlameRetired is offline
    Forum Moderator
    Join Date
    01-21-2014
    Location
    St. Joseph, Illinois U.S.A.
    MS-Off Ver
    Office 365 v 2403
    Posts
    13,406

    Re: Formula required for a fixed fee amount

    Which one?
    Reply With QuoteRegister To Reply
  6. 08-17-2017, 02:36 AM #6
    leelnich
    leelnich is offline
    Forum Expert leelnich's Avatar
    Join Date
    03-20-2017
    Location
    Delaware, USA
    MS-Off Ver
    Office 2016
    Posts
    2,807

    Re: Formula required for a fixed fee amount

    1) Which solution worked?
    2) If complete, please mark your thread as SOLVED (Thread Tools up top). -Lee

    Please click the Add Reputation star below any helpful posts, and use Thread Tools (up top) to mark your thread as SOLVED once you have your answer. Thanks!-Lee
    Last edited by leelnich; 08-17-2017 at 03:24 AM.
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Calculate an end date for fixed amount of work by a variable amount of monthly effort
    By FatFingers in forum Excel General
    Replies: 2
    Last Post: 11-21-2014, 09:35 AM
  2. Formula/Macro required to special paste in Fixed Asset schedule
    By Fletch74 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 02-05-2014, 06:58 PM
  3. Removing a fixed amount of time from a formula that is calculating working hours
    By Gremlin_za in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 12-10-2012, 08:19 AM
  4. Formula for chosing fixed amount of numbers
    By tonyvma in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 09-03-2010, 08:01 PM
  5. how to calculate if one cell amount differ & other cell amount fixed
    By avk in forum Excel General
    Replies: 1
    Last Post: 03-03-2010, 05:26 AM
  6. Formula to return maximum amount between fixed value and vlookup result
    By simon4sam in forum Excel General
    Replies: 3
    Last Post: 08-13-2008, 08:25 AM
  7. How to add a fixed amount to all cells in a column
    By ste5442 in forum Excel General
    Replies: 1
    Last Post: 06-30-2008, 08:04 AM

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1