1. Computer problem? Tech Support Guy is completely free -- paid for by advertisers and donations. Click here to join today! If you're new to Tech Support Guy, we highly recommend that you visit our Guide for New Members.

Excel Formula Help

Discussion in 'Business Applications' started by Penelope-Jenn, Jul 8, 2014.

Thread Status:
Not open for further replies.
Advertisement
  1. Penelope-Jenn

    Penelope-Jenn Thread Starter

    Joined:
    Mar 9, 2008
    Messages:
    31
    I am looking to create a spreadsheet that calculates vacation accrual and takes into account Flex Days, etc. Vacation accrual is accumulated at 6% of someones gross pay so at the end of 52 weeks, it would add up to their alotted vacation. I.E. I get 3 weeks a year. Not everyone gets Flex Days so I would only calculate this for those that get them.

    Are you able to assist me in coming up with the proper formula?
     
  2. The Villan

    The Villan

    Joined:
    Feb 20, 2006
    Messages:
    2,255
    PM sent
     
  3. The Villan

    The Villan

    Joined:
    Feb 20, 2006
    Messages:
    2,255
    When you say 3 weeks, do you mean 15 working days or 21 days?
     
  4. The Villan

    The Villan

    Joined:
    Feb 20, 2006
    Messages:
    2,255
    6% of gross pay, would be different for each person. So how do you define what % means in terms of days for each person? Do you have a scale? For example

    20,000 =1 day
    25,000 = 2 days
    30, 000 = 3 days
    etc etc
     
  5. Penelope-Jenn

    Penelope-Jenn Thread Starter

    Joined:
    Mar 9, 2008
    Messages:
    31
    I am not sure I understand the question. Did you mean $20,000/yr would get 1 day at a 6% calculation?
     
  6. The Villan

    The Villan

    Joined:
    Feb 20, 2006
    Messages:
    2,255
    Yes. you need to say what constitutes each days holiday.
     
  7. The Villan

    The Villan

    Joined:
    Feb 20, 2006
    Messages:
    2,255
    Example Vlookup sent to you as a spreadsheet. Just simple at this moment until I know all your requirements.
     
  8. Sponsor

As Seen On
As Seen On...

Welcome to Tech Support Guy!

Are you looking for the solution to your computer problem? Join our site today to ask your question. This site is completely free -- paid for by advertisers and donations.

If you're not already familiar with forums, watch our Welcome Guide to get started.

Join over 733,556 other people just like you!

Loading...
Thread Status:
Not open for further replies.

Short URL to this thread: https://techguy.org/1129272

  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.
    Dismiss Notice