rentonhighlands
Board Regular
- Joined
- Jul 31, 2014
- Messages
- 121
- Office Version
- 365
- Platform
- Windows
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?
=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?
Last edited: