IF Function - Too Many Arguments

I'm creating a new spreadsheet to improve staff scheduling and labor forecasting.

I have no problem with the formula to calculate total number of hours worked for a specific person for a specific shift. My challenge is that I need that cell to return different results based on the total number of hours worked.

If the person is scheduled for 9 or more hours, I need the total to deduct 1 hour
If the person is scheduled for 6 or more hours, I need the total to deduct .5 hours
if the person is scheduled for less than 6 hours, I need total to show without any deductions.
If the person is not scheduled, I need the total to be zero.

When trying to create an IF formula for this, I get an error about too many arguments.

C6 D6 E6
Start End Hrs
9:00 AM 3:00 PM 6.00

What formula can I enter into cell E6 to achieve the above mentioned criteria?

Thanks!

Originally Posted by Sambo kid

This is what I wrote...
=if(A6>=9,A6-1,if(and(A6>=6,A6<9),A6-0.5,if(and(A6<6,A6>0),A6,"")))
This assumes you have the hours worked in column A. Just repoint to where you have the hours, it worked for me.

Thanks for the reply. That formula did not work. I may not have explained it correctly.
Assume that the total appearing in E6 is the sum of (D6-C6)

C6 D6 E6
Start End Hrs
9:00 AM 3:00 PM 6.00

Any help you could provide would be greatly appreciated!

Thanks!

Please see the attached spreadsheet. Review the Hours column for the total.

How can I achieve the desired results mentioned previously?

Hi svconners,

Pls see attached file with accurate formula In E6

Hope this will work for u

Thanks,
A

Originally Posted by svconners

I'm creating a new spreadsheet to improve staff scheduling and labor forecasting.

I have no problem with the formula to calculate total number of hours worked for a specific person for a specific shift. My challenge is that I need that cell to return different results based on the total number of hours worked.

If the person is scheduled for 9 or more hours, I need the total to deduct 1 hour
If the person is scheduled for 6 or more hours, I need the total to deduct .5 hours
if the person is scheduled for less than 6 hours, I need total to show without any deductions.
If the person is not scheduled, I need the total to be zero.

When trying to create an IF formula for this, I get an error about too many arguments.

C6 D6 E6
Start End Hrs
9:00 AM 3:00 PM 6.00

What formula can I enter into cell E6 to achieve the above mentioned criteria?

Thanks!

Solved!

Thanks so much!

Great !!...........