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)