figuring pay

Barbie96

New Member
Joined
Oct 12, 2002
Messages
4
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 is the shortcut key for Format Selection?
Ctrl+1 (the number one) will open the Format dialog for whatever is selected.

Yogi Anand

MrExcel MVP
Joined
Mar 12, 2002
Messages
11,454
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

New Member
Joined
Oct 12, 2002
Messages
4
Yogi,

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

Emily

Active Member
Joined
Aug 28, 2002
Messages
304
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

MrExcel MVP
Joined
Mar 12, 2002
Messages
11,454

ADVERTISEMENT

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

Active Member
Joined
Aug 28, 2002
Messages
304
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

MrExcel MVP
Joined
Mar 12, 2002
Messages
11,454

ADVERTISEMENT

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

New Member
Joined
Oct 12, 2002
Messages
4
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

MrExcel MVP
Joined
Mar 12, 2002
Messages
11,454
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
 

Forum statistics

Threads
1,143,613
Messages
5,719,710
Members
422,242
Latest member
hishamkhatri

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.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

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

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

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
Top