combining --mid function with ifiserror function

**kadi** · 06-24-2011, 02:40 PM

Dear all,

I know how to do following functions seperately

1 =--MID(A2,3,10)
2 =IF(ISERROR(E3+F3),"",E3+F3)

but for my work, i want to combine these two functions

If you can have a look at my attached excel sheet, then in cell B8, there is #VALUE!

i dont know how to combine function 1 and 2 mentioned above.

will be very happy, if somebody can help me
thanks in advance,
kadi

**NBVC** · 06-24-2011, 02:52 PM

I don't understand how you want them combined. They are not related.

Please explain with words what it is you want to achieve.

**kadi** · 06-24-2011, 06:51 PM

dear moderator, i am reaally sorry for not putting it right.

I have two columns A and B, with 100 rows.
column B is actually made from column A,
the used function converts to text to numeric.
In column A, ther are few rows missing, therefore when I use a formula based on column A, it is obviuos for the error to come in. But I dont want that error #value! to be displayed, therefore I wanted to use the IF ISERROR function along with mid function, but then i didnt know how to combine that along with mid function

thanks for your time

**martindwilson** · 06-25-2011, 07:48 AM

try
=IF(ISERROR(--MID(A1,3,10)),0,--MID(A1,3,10))

**kadi** · 06-27-2011, 03:21 PM

Thank you so much, it works now
out of curiosity, from where do u all learn such tips, i tried to look in help files from excel, but couldnt get this information.
thanks again for inspiration.