figuring pay

Barbie96

New Member
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

Excel Facts

What do {} around a formula in the formula bar mean?
{Formula} means the formula was entered using Ctrl+Shift+Enter signifying an old-style array formula.
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

Yogi,

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

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

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

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

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

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.

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

Yogi,

Sincerely,
Barbara

Replies
0
Views
160
Replies
11
Views
314
Replies
3
Views
560
Replies
2
Views
475
Replies
4
Views
467

Forum statistics

1,221,051
Messages
6,157,627
Members
451,426
Latest member
VinnyDoesntKnowExcelCode

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back