# Need help with a max on PTO Accrual

1. ## 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.

2. ## 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.

3. ## 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. ## 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. ## Re: Need help with a max on PTO Accrual

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

6. ## Re: Need help with a max on PTO Accrual

IT WORKS!!! Thank you so much!

7. ## 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.

##### Users Browsing this Thread

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

#### 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