| 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 |
| 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) | |||
Threaded Mode
