| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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. |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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. |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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. |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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. |
|
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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! |
|
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 - |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| What Formula to use(VBA will be great to) | Excel Discussion (Misc queries) | |||
| Pivot table - default answer | Excel Discussion (Misc queries) | |||
| Still looking for answer that works,&.appreciate past efforts | Excel Worksheet Functions | |||
| I put a Calc. in to get a total IE =K12 the answer comes up as 0 | Excel Discussion (Misc queries) | |||
| how do I make excel 2003 my default spreadsheet over ms works spr. | Setting up and Configuration of Excel | |||
Linear Mode
