Help combining ISERROR and CONCATENATE.

[giallofever]

I got this last night, and decided to see if I can combine two equations if possible.

Here is what I have:

Please Login or Register  to view this content.

Values returned:

Please Login or Register  to view this content.

Can I combine these equations (C,D) into one cell (C), instead of two separate cells?

Thanks in advance guys.

[daddylonglegs]

Try

=TEXT(IF(ISERR(B1+0),A1,B1),"400000000000")

[giallofever]

Solved: =if(iserror(value($b3)),concatenate(4,rept(0,11-len($a3)),$a3),$b3)

[giallofever]

BTW, Thanks everyone in the forums for all your time and help. I am learning an enormous amount about Excel and everyone has been so nice.