If total answer is over default of 160 then 160, otherwise the formula i have works great!

[debbiep]

=IF(M19>29.9,G19*5,(N19+O19+P19+R19+S19+T19)*G19)

This formula deciphers part time versus full time hours and then adds
the rates together; however, I need it to also determine that if the
total adds up to over $160, then the answer should default to $160.
Only if the total is over $160.

The formula works great, just missing a part to default to a weekly
rate. Is this possible or do I have to add another column. I would
prefer it to be added to this formula if at all possible.
Thank you in advance.

 

[Pete_UK]

If your formula works, then you could modify it to this in the same
cell:

=MIN(160,IF(M19>29.9,G19*5,(N19+O19+P19+R19+S19+T19)*G19))

Hope this helps.

Pete

 

[Guest]

=IF(your_formula>160,160,your_formula)

 

[Roger Govier]

Hi
Try
=MIN(IF(M19>29.9,G19*5,(SUM(N19:T19)-Q19)*G19),160)
If Q19 is a blank cell, then you can omit the -Q19 from the formula.

 

[Guest]

=MIN(160,IF(M19>29.9,5,SUM(N1919,R19:T19))*G19)

 

[debbiep]

If your formula works, then you could modify it to this in the same
cell:

=MIN(160,IF(M19>29.9,G19*5,(N19+O19+P19+R19+S19+T19)*G19))

Hope this helps.

Pete





- Show quoted text -

Thank you Pete. It works perfect. You guys are the greatest!

 

[Pete_UK]

Thanks for the feedback - glad it worked.

Pete

Thank you Pete. It works perfect. You guys are the greatest!- Hide quoted text -

- Show quoted text -