| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Calculations Using the =IF formula
For the life of me I cannot figure out how to work this problem from a
textbook. Here it is If hours<=40, then gross pay=rate*hours, otherwise gross pay=rate*hours+.05*rate*(Hours-4) b4=rate c4=hours e4=ytd social security f4=gross pay g4=soc sec. a5=max soc sec. I am at my wits end. Thanks |
|
#2
|
|||
|
|||
|
Hi
Is this what you are after ?? In F4 =IF(C4<=40,B4*C4,B4*C4+(B4*0.05*(C4-4))) HTH Michael "ChesireCat" wrote: For the life of me I cannot figure out how to work this problem from a textbook. Here it is If hours<=40, then gross pay=rate*hours, otherwise gross pay=rate*hours+.05*rate*(Hours-4) b4=rate c4=hours e4=ytd social security f4=gross pay g4=soc sec. a5=max soc sec. I am at my wits end. Thanks |
|
#3
|
|||
|
|||
|
Michael's formula will do what ChesireCat asked for, but I'll bet 0.05
should be 0.5 (ie, time-and-a-half, not time plus 5%). -- Regards, Fred Please reply to newsgroup, not e-mail "Michael" wrote in message ... Hi Is this what you are after ?? In F4 =IF(C4<=40,B4*C4,B4*C4+(B4*0.05*(C4-4))) HTH Michael "ChesireCat" wrote: For the life of me I cannot figure out how to work this problem from a textbook. Here it is If hours<=40, then gross pay=rate*hours, otherwise gross pay=rate*hours+.05*rate*(Hours-4) b4=rate c4=hours e4=ytd social security f4=gross pay g4=soc sec. a5=max soc sec. I am at my wits end. Thanks |
|
#4
|
|||
|
|||
|
Hi Fred
Yeah, I reckon your right, and the end of the formula should be C4-40 not C4-4. But we give 'em what they ask for !! Michael "Fred Smith" wrote: Michael's formula will do what ChesireCat asked for, but I'll bet 0.05 should be 0.5 (ie, time-and-a-half, not time plus 5%). -- Regards, Fred Please reply to newsgroup, not e-mail "Michael" wrote in message ... Hi Is this what you are after ?? In F4 =IF(C4<=40,B4*C4,B4*C4+(B4*0.05*(C4-4))) HTH Michael "ChesireCat" wrote: For the life of me I cannot figure out how to work this problem from a textbook. Here it is If hours<=40, then gross pay=rate*hours, otherwise gross pay=rate*hours+.05*rate*(Hours-4) b4=rate c4=hours e4=ytd social security f4=gross pay g4=soc sec. a5=max soc sec. I am at my wits end. Thanks |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Match / Vlookup within an Array formula | Excel Discussion (Misc queries) | |||
| Relative Indirect Formula Referencing? | Excel Worksheet Functions | |||
| Countif Formula with 2 calculations | Excel Discussion (Misc queries) | |||
| formula to sum all sum calculations in a column | Excel Worksheet Functions | |||
| Can you enter a formula in a cell that auto-inputs calculations a. | Excel Worksheet Functions | |||
Linear Mode
