Greater than less than display - (IF(AND)) formula

[ThatDudeRyan]

I have a sheet that I am working on for doing an hours breakdown. I have 2 columns, one that deals with regular hours and one with overtime. I have an hours box and then the formula in the columns designates the number of regular hours (no more than 8) and then put the rest into the overtime. I have the overtime figured out but I am not able to get the right number of hours to display for the regular. I have the formula:

IF(AND(B3>0,B3<=8),B3*L11,0)

With this formula though if I put in 10 hours it will show 2 overtime hours and 0 regular hours (since it is above 8).

Thanks for any help.
Ryan

 

[Fluff]

Hi & welcome to MrExcel.
Change the 0 at the end to 8*L11 assuming you want to multiply the standard hours by L11

 

[ThatDudeRyan]

EDIT: I think that I may need to do another IF statement instead of the AND

 

[ThatDudeRyan]

I hate not being able to edit. To just clarify the Hours are B3 and the number of techs is L11. Sorry

 

[ThatDudeRyan]

Fluff,

That worked... so simple...

Thanks,
Ryan

 

[Fluff]

You're welcome & thanks for the feedback