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

spot the mistake in formula
 

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

--
__________________________________
HTH

Bob

"stew" wrote in message
...
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

spot the mistake in formula
 

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

Well you live and Learn

Thanks

Stew

"Bob Phillips" wrote:

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

--
__________________________________
HTH

Bob

"stew" wrote in message
...
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

spot the mistake in formula
 

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

--
__________________________________
HTH

Bob

"stew" wrote in message
...
I thought that only applied to if and and functions which I count 7

Well you live and Learn

Thanks

Stew

"Bob Phillips" wrote:

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

--
__________________________________
HTH

Bob

"stew" wrote in message
...
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