if, nested if, if(and) logic

I have the attached file I am hoping someone can help me reason out a formula change for. What I am trying to do is say when any cell in range G11:U11 is 6200 or greater then I need to somehow account for the extra time in cell B18 into the formula in cell D25 which is:

[code]
=IF(R20<=TIME(10,0,0),R20,IF(AND((R20)>TIME(10,0,0),R20<=TIME(11,45,0)),R20+TIME(0,B14,0),IF(AND((R20)>=TIME(12,0,0),R20+TIME(1,0,0)<TIME(14,30,0)),B25+TIME(0,F16+60,0)+TIME(0,B14,0),IF((TIME(0,F16,0)+B25)>TIME(14,30,0),TIME(14,30,0),TIME(14,30,0)))))
[\code]

I hope this is understandable. I would put it in psudo code but I am not sure of the logistic of how to account to the cutter flip time in cell B18 in the D25 cell.

Can't you just append another IF?

+IF(COUNTIF(G11:U11,6200)>1,B18,0)

I am not familiar with count IF let me try it.

The actual formula should be

+IF(COUNTIF(G11:U11,6200)>0,B18,0)

Ok I don't understand and think I miss spoke. I don't want to add cell B18 if any one of the cell in range G11:U11. For D25 I only want to add in the value of cell B18 if G11>6200.

Ok I tried the following change:

[code]
=IF(R20<=TIME(10,0,0),R20,IF(AND((R20)>TIME(10,0,0),R20<=TIME(11,45,0)),R20+TIME(0,B14,0),IF((S20)>=TIME(12,5,0),S20+TIME(1,0,0),IF(S20>=TIME(14,30,0),TIME(14,30,0),0)+IF(G11>=62000,+time(0,B18,0),0))))
[\code]

However instead of adding the value of 10 in cell B18 it is adding 16???????

*note* I found if I put 4 in cell B14 I get the 10 that I was wanting to add????

That is because R20 and S20 have different values if G11 holds more than the basic 6000, so the first part of your formula is picking up n extra 16 seconds.

Any suggestions?

Suggestions for what? I explained why you get the results that you do.

Let me look closer

I am terrible at putting together if(and) functions. Can someone look at the below function and tell me where the mistakes are?

Please Login or Register  to view this content.

I think the problem is with the last If(and) portion of the equation but I have gone around and around with no resolution on my own. I also tried to verify the last IF(and)

Please Login or Register  to view this content.

It didn't work so I am all but convinced this is where the problem lies.