spot the mistake in formula

[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

 

[Bob Phillips]

Too many nested functions methinks - you can only have 7.

 

[stew]

I thought that only applied to if and and functions which I count 7

Well you live and Learn

Thanks

Stew

 

[Bob Phillips]

No, that is what is mostly where it occurs, but it is nested formulas, not
nested IFs.