S
stew
Hi all
can anybody spot the practical mistake in this Formula
=IF(M$3="NONE","",IF(RIGHT(INDIRECT("'Personel
'!"&ADDRESS(4,(INT(ROW()/1)-6))),6)="MEMBER"," ",IF(AND(INDIRECT("'Date
Details'!"&ADDRESS(7,(COLUMN()+1)))="Day Off",L5<200),INDIRECT("'Personel
'!"&ADDRESS(4,(INT(ROW()/1)-6))),IF(M$16="Early Check in
Required","",IF('Date Details'!O$36>200,"",IF(INDIRECT("'Personel
'!"&ADDRESS(4,(ROW()/1)-6))=M26,"",INDIRECT("'Personel
'!"&ADDRESS(4,(ROW()/1)-6))))))
Thanks for looking
can anybody spot the practical mistake in this Formula
=IF(M$3="NONE","",IF(RIGHT(INDIRECT("'Personel
'!"&ADDRESS(4,(INT(ROW()/1)-6))),6)="MEMBER"," ",IF(AND(INDIRECT("'Date
Details'!"&ADDRESS(7,(COLUMN()+1)))="Day Off",L5<200),INDIRECT("'Personel
'!"&ADDRESS(4,(INT(ROW()/1)-6))),IF(M$16="Early Check in
Required","",IF('Date Details'!O$36>200,"",IF(INDIRECT("'Personel
'!"&ADDRESS(4,(ROW()/1)-6))=M26,"",INDIRECT("'Personel
'!"&ADDRESS(4,(ROW()/1)-6))))))
Thanks for looking