+ Reply to Thread
Results 1 to 7 of 7

Need help with a max on PTO Accrual

  1. #1
    Registered User
    Join Date
    11-08-2019
    Location
    Port St. Lucie, FL
    MS-Off Ver
    2010
    Posts
    6

    Need help with a max on PTO Accrual

    I need to have an accrual stop amount for my end formula. In another post you gave a < > example, I was thinking of a MAX IF: But unsure how either would work within my formulas.

    I'm attaching, hope you can help.
    Attached Files Attached Files
    Angie

  2. #2
    Registered User
    Join Date
    11-05-2019
    Location
    Kaysville, UT
    MS-Off Ver
    Office 365
    Posts
    78

    Re: Need help with a max on PTO Accrual

    Actually it is MIN you want to use. See the attachment. By the way the end formulas were not consistent for all rows in what you sent. I don't know why so I made them all consistent. You may need to adjust back for that.
    Attached Files Attached Files

  3. #3
    Registered User
    Join Date
    11-08-2019
    Location
    Port St. Lucie, FL
    MS-Off Ver
    2010
    Posts
    6

    Re: Need help with a max on PTO Accrual

    Thank you so much for your help, however, how do you change the max amount? it should be 240 but your formula has $R$3.

    some of the formulas were different to account for accrual changes and length of time with the company.. .

    So, I can put the correct =MIN($R$3, in front of all of my formulas and it will be all good?

  4. #4
    Registered User
    Join Date
    11-05-2019
    Location
    Kaysville, UT
    MS-Off Ver
    Office 365
    Posts
    78

    Re: Need help with a max on PTO Accrual

    So the cell in $R$3 is where the number is, just change the cell to 240. So yes the MIN( in front then a comma before your formula and a closing ) at then end should work with different versions of the formula.

  5. #5
    Registered User
    Join Date
    11-08-2019
    Location
    Port St. Lucie, FL
    MS-Off Ver
    2010
    Posts
    6

    Re: Need help with a max on PTO Accrual

    =MIN(240,(J10+O10-E10))
    So this is good?

  6. #6
    Registered User
    Join Date
    11-08-2019
    Location
    Port St. Lucie, FL
    MS-Off Ver
    2010
    Posts
    6

    Re: Need help with a max on PTO Accrual

    IT WORKS!!! Thank you so much!

  7. #7
    Registered User
    Join Date
    11-05-2019
    Location
    Kaysville, UT
    MS-Off Ver
    Office 365
    Posts
    78

    Re: Need help with a max on PTO Accrual

    Glad it works. Go ahead and mark the thread solved. You can also say thank you by adding to reputation.

+ 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