M m9vukyem Member Jun 2, 2021 #1 Dear sir, Prevously i have extract the amount using below formula from bank statement now it gives false result =IFERROR(IFERROR(MID(F2,1,LEN(F2)-3)+0,MID(SUBSTITUTE(F2,",",""),2,LEN(F2)-10)*1),0) Attachments Book1.xlsx 22.7 KB · Views: 5
Dear sir, Prevously i have extract the amount using below formula from bank statement now it gives false result =IFERROR(IFERROR(MID(F2,1,LEN(F2)-3)+0,MID(SUBSTITUTE(F2,",",""),2,LEN(F2)-10)*1),0)
M m9vukyem Member Jun 2, 2021 #2 =IFERROR(IFERROR(MID(SUBSTITUTE(F5,",",""),1,LEN(SUBSTITUTE(F5,",",""))-3)+0,MID(SUBSTITUTE(M11,",",""),2,LEN(M11)-10)*1),0) is it correct formla to extract the amount
=IFERROR(IFERROR(MID(SUBSTITUTE(F5,",",""),1,LEN(SUBSTITUTE(F5,",",""))-3)+0,MID(SUBSTITUTE(M11,",",""),2,LEN(M11)-10)*1),0) is it correct formla to extract the amount