Showing blank if there is an Error in the cell

[akinkaraman]

I tried to show the cell as blank if my formula works with the cell which has error or "N/A" but it still shows error at Line 15 at Table B.

(Line 7 and Line 23 works but Line 15 has errors.)

Could you please help me to fix the formulas for Line 7,15 and 23?

Thanks in Advance..

 

[blazy]

Hey,

don't know if I understood correctly: will the foolowing formulae work for you?

Put this formula in C15 and drag it to the right.

=IFERROR(IF(COLUMNS(D15:$I15)>LEN($C12),"",0+LEFT(RIGHT($C12;COLUMNS(D15:$I15)),1)),"")

KR

 

[akinkaraman]

The formula above gave error because of I use the Turkish Excel..
Can you add your file here?

 

[blazy]

Hey,

just switch "," to ";" (in future cases).

In attached file, see two sheets.

KR

 

[akinkaraman]

blazy Thank you very much..

 

[blazy]

you are more than welcome friend!