View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
SteW SteW is offline
external usenet poster
 
Posts: 293
Default spot the mistake in formula

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$36200,"",IF(INDIRECT("'Personel
'!"&ADDRESS(4,(ROW()/1)-6))=M26,"",INDIRECT("'Personel
'!"&ADDRESS(4,(ROW()/1)-6))))))

Thanks for looking