+ Reply to Thread
Results 1 to 4 of 4

If then statement help for accrual cap

  1. #1
    Registered User
    Join Date
    09-16-2013
    Location
    Amherst MA
    MS-Off Ver
    Excel 2003
    Posts
    12

    If then statement help for accrual cap

    I have the following calculation to calculate the number of days available to a person for vacation leave.
    I17 is previous total, C18 is the new accrued amount, and F18 is the amount of time used.

    I want the new answer to test to see if the person has gone over 120 hours. If they have, then I want the answer to be 120 for any calculation that equals more than 120 hours.

    How do I write the if, then statement for this?
    Thank you!


    =SUM(I17,C18)-F18

  2. #2
    Forum Expert Ace_XL's Avatar
    Join Date
    06-04-2012
    Location
    UAE
    MS-Off Ver
    2016
    Posts
    6,074

    Re: If then statement help for accrual cap

    Use

    =MIN(your_calculation,120)
    Life's a spreadsheet, Excel!
    Say thanks, Click *

  3. #3
    Forum Guru sktneer's Avatar
    Join Date
    04-30-2011
    Location
    Kanpur, India
    MS-Off Ver
    Office 365
    Posts
    9,647

    Re: If then statement help for accrual cap

    Do you want this?

    =IF(SUM(I17,C18)-F18>120,120,SUM(I17,C18)-F18)
    Regards
    sktneer


    Treat people the way you want to be treated. Talk to people the way you want to be talked to.
    Respect is earned NOT given.

  4. #4
    Registered User
    Join Date
    09-16-2013
    Location
    Amherst MA
    MS-Off Ver
    Excel 2003
    Posts
    12

    Re: If then statement help for accrual cap

    Like this?

    MIN(I17+C18-F18),160

+ 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. PTO Accrual
    By Jpayne24 in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 04-08-2013, 08:02 PM
  2. accrual template
    By greene0911 in forum Excel General
    Replies: 1
    Last Post: 03-18-2013, 10:27 AM
  3. Excel 2008 : Help with vacation accrual
    By LSporte in forum Excel General
    Replies: 0
    Last Post: 03-27-2012, 01:25 PM
  4. PTO Accrual
    By scampbell729 in forum Excel General
    Replies: 2
    Last Post: 10-19-2011, 08:37 AM
  5. Vacation Accrual
    By kanolan in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 04-09-2009, 02:56 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