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"))))))))
 
Joined
Aug 21, 2009
Messages
4
Reaction score
0
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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

excel 2003 If function 4
Nested IF functions 5
merging ranges in VBA 2
if function 3
if function 1
Is there a specific Excel Function that doesn't this? 4
Not Sure on Function 1
Nesting IF/OR Statement 14

Top