| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| X marks the spot | Excel Discussion (Misc queries) | |||
| Time formula returns night time by mistake | Excel Discussion (Misc queries) | |||
| Hosur an IT hot spot? | Excel Worksheet Functions | |||
| Is there a formula that can spot duplicate reference des's | Excel Worksheet Functions | |||
| mistake in formula | Excel Discussion (Misc queries) | |||
Linear Mode
