Hi there,

Can anyone help me in simplifying the following formula:

=IF(AND('Shift Entry'!$I6="Y",(AND((OR('Shift Entry'!$E6<=1,'Shift
Entry'!$E6<2)))),('Shift Entry'!$F6>1)),1,IF(AND('Shift
Entry'!$V6="Y",(AND((OR('Shift Entry'!$R6<=1,'Shift
Entry'!$R6<2)))),('Shift Entry'!$S6>1)),1,IF(AND('Shift
Entry'!$AI6="Y",(AND((OR('Shift Entry'!$AE6<=1,'Shift
Entry'!$AE6<2)))),('Shift Entry'!$AF6>1)),1,IF(AND('Shift
Entry'!$AV6="Y",(AND((OR('Shift Entry'!$AR6<=1,'Shift
Entry'!$AR6<2)))),('Shift Entry'!$AS6>1)),1,0))))

Many thanks - David