Concatenate formula

[rentonhighlands]

How can I write a =concatenate formula that says this
=concatenate(BD:BD,"/"BE:BE)
BE2 has a #N/A in it.
How can I write the formula and have it return only what is in BD and remove the #N/A?

or
Is a =if statement a better option?

 

[Scott Huish]

How can I write the formula and have it return only what is in BD and remove the #N/A?

That doesn't make sense to me. If #N/A is in the cell and you remove it what is left in the cell to return?

 

[rentonhighlands]

How can I write the formula and have it return only what is in BD and remove the #N/A that is in BE?

 

[Eric W]

Are you looking for something like this?

=IFERROR(BD1,"")&"/"&IFERROR(BE1,"")

 

[Scott Huish]

If you only want it to put the / if there are 2 actual values:
=SUBSTITUTE(TRIM(IFERROR(BD1&" ","")&IFERROR(BE1,""))," ","/")