+ Reply to Thread
Results 1 to 2 of 2

Uniform Allowance - Formula for Totals in Excess of Allowance

  1. #1
    Registered User
    Join Date
    02-15-2012
    Location
    28117
    MS-Off Ver
    Excel 2010
    Posts
    2

    Question Uniform Allowance - Formula for Totals in Excess of Allowance

    I am creating a uniform allowance spreadsheet to make tracking employee purchases simple.

    Data

    Allowance: 150
    This is the amount of money the employee is entitled to for uniforms

    Price:
    This is the actual price of the uniform

    Employee Cost:
    This is the amount billed to the employee. They are billed anything over $150.



    My problem is how to set up the formula for Employee Cost. I have Allowance in A6, Total Amount Purchased in G25, Price in G3-G23 and Emplyee Cost in H3-H23.


    Thanks so much in advance ... this has had me stumped for awhile!

  2. #2
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    44,464

    Re: Excel Formula Help - Uniform Allowance - Formula for Totals in Excess of Allowanc

    If the allowance is in cell A6 and the total purchased is in cell G25 (=SUM(G3:G23)) then the amount billed to the employee in cell H25 must be =G25-A6

    Am I missing something? I'm not sure what is in H3 to H23

    Regards, TMS
    Trevor Shuttleworth - Retired Excel/VBA Consultant

    I dream of a better world where chickens can cross the road without having their motives questioned

    'Being unapologetic means never having to say you're sorry' John Cooper Clarke


  3. #3
    Registered User
    Join Date
    02-15-2012
    Location
    28117
    MS-Off Ver
    Excel 2010
    Posts
    2

    Re: Uniform Allowance - Formula for Totals in Excess of Allowance

    Thank you for trying! I knew I'd leave something out! Sorry!

    A6 is currently set up as the allowance MINUS G3:G23 so that the value in A6 (originally 150) will reflect the amount of the allowance LEFT at any given time and each line G3:G23 is a different item of apparel, with an individual price and thus, an individual amount to be billed to the employee. It's because of this always-changing value that I'm having a hard time figuring a formula for Employee Cost, as I can't identify a constant.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Tags for this Thread

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