Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Function error
The below formula works, but when I add TRIM( at the * and, ) at **, I get
the message "The formula you typed contains an error." Please help. =IF(AND(ISBLANK('Paste USAL Cheque Data - temp'!B9),ISBLANK('Paste USAL Cheque Data - temp'!B8)),"",IF(MID(TRIM('Paste USAL Cheque Data - temp'!C9),1,1)="F",TRIM(PROPER(VLOOKUP(L2,'Debtor Names'!$A$2:$B$65536,2,FALSE))),IF(MID(TRIM('Paste USAL Cheque Data - temp'!C9),1,1)="M","USAL"&'Paste USAL Cheque Data - temp'!B9&" "&VALUE(MID(TRIM('Paste USAL Cheque Data - temp'!C9),2,6))&" "&TRIM(PROPER(VLOOKUP(VALUE(MID(*'Paste USAL Cheque Data - temp'!C9**,2,6)),'Debtor Names'!$A$2:$B$65536,2,FALSE))),'Paste USAL Cheque Data - temp'!$B$4&" "&'Paste USAL Cheque Data - temp'!$A$6&'Paste USAL Cheque Data - temp'!$B$6))) |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Function error
Too many nested functions. You need to break the formula down into separate
cells. -- __________________________________ HTH Bob "nc" wrote in message ... The below formula works, but when I add TRIM( at the * and, ) at **, I get the message "The formula you typed contains an error." Please help. =IF(AND(ISBLANK('Paste USAL Cheque Data - temp'!B9),ISBLANK('Paste USAL Cheque Data - temp'!B8)),"",IF(MID(TRIM('Paste USAL Cheque Data - temp'!C9),1,1)="F",TRIM(PROPER(VLOOKUP(L2,'Debtor Names'!$A$2:$B$65536,2,FALSE))),IF(MID(TRIM('Paste USAL Cheque Data - temp'!C9),1,1)="M","USAL"&'Paste USAL Cheque Data - temp'!B9&" "&VALUE(MID(TRIM('Paste USAL Cheque Data - temp'!C9),2,6))&" "&TRIM(PROPER(VLOOKUP(VALUE(MID(*'Paste USAL Cheque Data - temp'!C9**,2,6)),'Debtor Names'!$A$2:$B$65536,2,FALSE))),'Paste USAL Cheque Data - temp'!$B$4&" "&'Paste USAL Cheque Data - temp'!$A$6&'Paste USAL Cheque Data - temp'!$B$6))) |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
if function error | Excel Worksheet Functions | |||
Possible error in MOD function | Excel Worksheet Functions | |||
If error function | Excel Worksheet Functions | |||
3D Function Error | Excel Discussion (Misc queries) | |||
IF THEN function error | Excel Worksheet Functions |