PuntingJawa
Board Regular
- Joined
- Feb 25, 2021
- Messages
- 140
- Office Version
- 365
- 2019
- Platform
- Windows
If Column B has a specified number I would like to string together a series of cells into a Cell G through and H. If the value isn't there then I would like it to skip. However, I would like it to not skip cells.
Example.
=IF(B1=2,"TheirP/N "&D5&" Our P/N "&E5&" Serial # "&C5,"")
So, if B1 is equal to 2 then return "TheirP/N " and D5 value and " Our P/N " and E5 Value and "Serial# " and C5 Value.
This is what I have so far. What I am trying to do is make it to when I place this in G1 that it does not leave blank cells. Is this possible?
Example.
=IF(B1=2,"TheirP/N "&D5&" Our P/N "&E5&" Serial # "&C5,"")
So, if B1 is equal to 2 then return "TheirP/N " and D5 value and " Our P/N " and E5 Value and "Serial# " and C5 Value.
This is what I have so far. What I am trying to do is make it to when I place this in G1 that it does not leave blank cells. Is this possible?