I have a schedule - one employee works 4 hours, one works 8 hours, one works
6 hours.

I need to set up a conditional statement that will print out his or her
lunch as follows:

K5 is the number of hours the employee actually is in the store, and I'm
calculating K5 in one cell, and then doing the lunch time calculations in a
second cell.

IF (K5 <= 5) THEN (Lunch Break = 0)
AND
IF (K5 5 and K5 <8 ) THEN (Lunch Break = 30)
AND
IF (K5 = 8) THEN (Lunch Break = 60)

K5 is derived other cells.

I know this can be done. I just can't get the syntax right.

Thanks for any help y'all can offer.

Hi

One way without IF statements
="Lunch Break = "&(30+30*(K58))*(K5=5)&" Minutes"

--
Regards

Roger Govier


"California Barbie" <California wrote
in message ...
I have a schedule - one employee works 4 hours, one works 8 hours, one
works
6 hours.

I need to set up a conditional statement that will print out his or
her
lunch as follows:

K5 is the number of hours the employee actually is in the store, and
I'm
calculating K5 in one cell, and then doing the lunch time calculations
in a
second cell.

IF (K5 <= 5) THEN (Lunch Break = 0)
AND
IF (K5 5 and K5 <8 ) THEN (Lunch Break = 30)
AND
IF (K5 = 8) THEN (Lunch Break = 60)

K5 is derived other cells.

I know this can be done. I just can't get the syntax right.

Thanks for any help y'all can offer.