I am trying to set up a spreadsheet to report on how we are meeting our
priority orders in line with time constraints

col A - Date
Col B - Time order in (format hh:mm)
Col C - Time order out (format as col b)
Col D - Is it a priority order Y/N
Col E - Time taken from receipt to complete (sum col c - col b) (format
[mm])

My problem is Col F where i am trying to return a figure/text for if
col d is a priority and col E is greater than 120 minutes

Tried =IF(E2=$K$2,D2=$L$2,1) where k2 = Y and L2 = 120 but it returns
FALSE for every cell that is a priority no matter how long it has
taken.

Any help gratefully received,

Frustrated




--
sonic-the-mouse