Excel Excel If Function

Joined
Aug 21, 2009
Messages
4
Reaction score
0
I am trying to create an IF function that when a parent signs in their child if the number falls betweens certain times they are charged a certain amount. For example, there is a 1 hour min. so if the child comes at 2:35pm and clocks out at 3:25pm they are charged for 1 hour. After the 1 hour min. they are charged every half hour. So I want to calculate the billable amount. I used this formula and it is not working, I hope I am close.
=IF(G3=0,"0",IF(K1<=G3<=L1,"1",IF(K2<=G3<=L2,"1.5",IF(K3<=G3<=L3,"2",IF(K4<=G3<=L4,"2.5",IF(K5<=G3<=L5,"3",IF(K6<=G3<=L6,"3.5",IF(K7<=G3<=L7,"3.75","10"))))))))
 
Can anyone help!!!!!!

Does anyone have any clue where I may be able to find out the answer to my question? I see this is a pretty difficult question.
 
Back
Top