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

=IF(M1929.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.

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

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

=MIN(160,IF(M1929.9,G19*5,(N19+O19+P19+R19+S19+T1 9)*G19))

Hope this helps.

Pete

On Mar 16, 1:02 am, wrote:
=IF(M1929.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.

If total answer is over default of 160 then 160, otherwise the for
 

=IF(your_formula160,160,your_formula)
--
Gary''s Student
gsnu200710


" wrote:

=IF(M1929.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.

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

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

Roger Govier


wrote in message
ups.com...
=IF(M1929.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.

If total answer is over default of 160 then 160, otherwise the for
 

=MIN(160,IF(M1929.9,5,SUM(N19:P19,R19:T19))*G19)


" wrote:

=IF(M1929.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.

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

On Mar 15, 9:09 pm, "Pete_UK" wrote:
If your formula works, then you could modify it to this in the same
cell:

=MIN(160,IF(M1929.9,G19*5,(N19+O19+P19+R19+S19+T1 9)*G19))

Hope this helps.

Pete

On Mar 16, 1:02 am, wrote:



=IF(M1929.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.- Hide quoted text -

- Show quoted text -

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

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

Thanks for the feedback - glad it worked.

Pete

On Mar 16, 3:27 am, wrote:
On Mar 15, 9:09 pm, "Pete_UK" wrote:





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

=MIN(160,IF(M1929.9,G19*5,(N19+O19+P19+R19+S19+T1 9)*G19))

Hope this helps.

Pete

On Mar 16, 1:02 am, wrote:

=IF(M1929.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.- Hide quoted text -

- Show quoted text -

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

- Show quoted text -