how to ignore error in foumla when combine the colomn

[sharadmaxwell]

Hiiiiii Experts
I am back again with the problme

Capture.JPG


see the above image
i want a formula in F1
Which take 1A full then last five digit of B1,C1 and D1
and if D1 has error should be ignore

[Sam Capricci]

seems to me the easiest way is to add this to your formula in column D to get rid of the #NUM! =iferror(your formula,"") Then something like this for the remainder... =A1&"/"&RIGHT(B1,5)&"/"&RIGHT(C1,5)&"/"&RIGHT(D1,5)

[sharadmaxwell]

thanks
it works but,
I have no idea how to add iferror in formula

below is my formula

=INDEX('[CHEQUE REGISTER - SHARAD.xlsm]CHQ REG-SHARAD'!$F$2:$F$2725, SMALL(IF($C780='[CHEQUE REGISTER - SHARAD.xlsm]CHQ REG-SHARAD'!$N$2:$N$2725, ROW('[CHEQUE REGISTER - SHARAD.xlsm]CHQ REG-SHARAD'!$N$2:$N$2725)-ROW('[CHEQUE REGISTER - SHARAD.xlsm]CHQ REG-SHARAD'!$N$2)+1), COLUMN('[CHEQUE REGISTER - SHARAD.xlsm]CHQ REG-SHARAD'!B$1)))

please add ifferror and reply me

[sharadmaxwell]

HII Sambo kid

AS PER YOUR FORMULA i.e

=A1&"/"&RIGHT(B1,5)&"/"&RIGHT(C1,5)&"/"&RIGHT(D1,5)
IF C1 AND D1 IS BLANK
"/" WILL SHOWN IN ANSWER
i DONT WANT "/" IF C1 OR D1 ARE BLANK

[Sam Capricci]

I might try adding the iferror here... =IFERROR(INDEX('[CHEQUE REGISTER - SHARAD.xlsm]CHQ REG-SHARAD'!$F$2:$F$2725, SMALL(IF($C780='[CHEQUE REGISTER - SHARAD.xlsm]CHQ REG-SHARAD'!$N$2:$N$2725, ROW('[CHEQUE REGISTER - SHARAD.xlsm]CHQ REG-SHARAD'!$N$2:$N$2725)-ROW('[CHEQUE REGISTER - SHARAD.xlsm]CHQ REG-SHARAD'!$N$2)+1), COLUMN('[CHEQUE REGISTER - SHARAD.xlsm]CHQ REG-SHARAD'!B$1))),"") but this is an untested guess.
Next, you hadn't mentioned that C1 could be blank too. Can you give all the details so a formula could be worked out.
Better yet, can you upload a small sample with no confidential data so we have actual examples to work with?

[FDibbins]

HII Sambo kid

AS PER YOUR FORMULA i.e

=A1&"/"&RIGHT(B1,5)&"/"&RIGHT(C1,5)&"/"&RIGHT(D1,5)
IF C1 AND D1 IS BLANK
"/" WILL SHOWN IN ANSWER
i DONT WANT "/" IF C1 OR D1 ARE BLANK

Without going too deeply into what you have, maybe...
=if(or(C1="",D1="","",A1&"/"&RIGHT(B1,5)&"/"&RIGHT(C1,5)&"/"&RIGHT(D1,5))