| 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. |
| 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 | |||
Threaded Mode
