if(and)

[nicolelschramartin]

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

[code]
=IF(D27<TIME(9,45,0),D27+TIME(0,B16,0),IF(AND((D27)>=TIME(9,45,0),D27<TIME(11,50,0)),D27+TIME(0,B14,0),IF(AND((D27)>=TIME(11,50,0),D27<=TIME(13,0,0)),D27+TIME(1,0,0),IF(AND(D27)>TIME(13,0,0),D27<=TIME(14,15,0)),D27+TIME(0,B13,0),IF(D27>TIME(14,15,0),TIME(14,30,0),"ERROR")))))
[\code]

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.

[vlady]

I have Pmed you regarding this same issue, please continue with the existing one to avoid to many thread which are all the same. You have at least five or more thread regarding this which we were not aware just today. You may continue on the other thread.

use this one.

http://www.excelforum.com/excel-form...and-logic.html



Thread closed!