figuring pay

[Barbie96]

I have a question on how to write an IF statement for the following scenario:
Column A B
Hours Pay Rate
38 $10
42 $10
54 $10

Hours under 40 are paid at $10, over $40 but less than 50 are paid at time and a half and
and hours over 50 are paid at double time, how do I write the IF statement. Please help, I'm really confused on this problem.
Thanks

 

[Yogi Anand]

Hi Barbie96:

Welcome to the board!

Try ...

'=A2*10+MAX((A2-40)*5,0)+MAX((A2-50)*5,0)

Regards!

Yogi

Edit: Hi Barbara, sorry I did not mention, you do not need an IF statement in this case. If you do want to use an IF statement, we can write a formula using IF function.
This message was edited by Yogi Anand on 2002-10-13 00:24

 

[Barbie96]

Yogi,

Thank you for the help.I really appreciate the information.
I was wondering what the IF statement would be for that problem.

 

[Emily]

for If statement

=IF(A2<=40, A2*10,IF(A2<=50,400+(A2-40)*15, 550+(A2-50)*20))
This message was edited by Emily on 2002-10-13 01:06

 

[Yogi Anand]

Hi Emily:

We don't want to overpay -- do we?

See we paid the person for all the hours worked at $10 per hour, then on top of that we paid (1.5-1)*10 for hours worked over 40, and similarly an additional $5 per hour for hours worked over 50, which effectively says

pay at $10 per hour upto 40 hours
and at $15 per hour for hours worked over 40
and at $20 per hour for hours worked over 50

Do you agree?

Regards!

Yogi

 

[Emily]

On 2002-10-13 01:01, Yogi Anand wrote:
Hi Emily:

We don't want to overpay -- do we?

See we paid the person for all the hours worked at $10 per hour, then on top of that we paid (1.5-1)*10 for hours worked over 40, and similarly an additional $5 per hour for hours worked over 50, which effectively says

pay at $10 per hour upto 40 hours
and at $15 per hour for hours worked over 40
and at $20 per hour for hours worked over 50

Do you agree?

Regards!

Yogi

Agree
My mistake

 

[Yogi Anand]

On 2002-10-13 00:33, Barbie96 wrote:
Yogi,

Thank you for the help.I really appreciate the information.
I was wondering what the IF statement would be for that problem.

Hi Barbara:

One of the ways the formula using the IF function can be written as is ...

=IF(A4<40,A4*10,IF(A4<50,40*10+(A4-40)*15,IF(A4>50,A4*10+(A4-40)*5+(A4-50)*5)))

Regards!

Yogi

 

[Barbie96]

Yogi,

Thanks for the If statement. It is just what I was looking for.
I'm am a displaced worker and have gone back to college after being out of high school for 34 years. I am taking quite a few computer classes( Excel and Database) are just two of the classes I'm taking this semester. It's been kind of hard getting back into the studying habits and sometimes I get overhelmed with some of the projects that are assigned, but I getting there. It's nice to know there is a place to go to get some help. Thanks again for your help.

 

[Yogi Anand]

Hi Barbara:

It is admirable that you are taking computer courses (picking up new skills) in your late youth -- you must be at least in your 30s -- right!

Well good luck to you -- and hopefully, we will chat again.

Regards!

Yogi

 

[Barbie96]

Yogi,
You've made me blush.
Thanks for your support.

Sincerely,
Barbara