spot the mistake in formula

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
 
S

stew

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

Well you live and Learn

Thanks

Stew
 
B

Bob Phillips

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top