# Calculations Using the =IF formula

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. ## RE: Calculations Using the =IF formula

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. ## Re: Calculations Using the =IF formula

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

"Michael" <Michael_MitchelsonNOSP@rta.nsw.gov.au> wrote in message
news:1E931D34-97AB-48E7-AF8E-D9DFA2823DE6@microsoft.com...
> 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. ## Re: Calculations Using the =IF formula

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
>
>
> "Michael" <Michael_MitchelsonNOSP@rta.nsw.gov.au> wrote in message
> news:1E931D34-97AB-48E7-AF8E-D9DFA2823DE6@microsoft.com...
> > 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

>
>
>

There are currently 1 users browsing this thread. (0 members and 1 guests)

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1