Forum Discussion

Copper Contributor

Mar 21, 2022

Solved

Concatenate IF Help

Good afternoon, I'm trying to get some help with a concatenate / IF formula on a spreadsheet that I'm working on. Basically, what I need is to populate a field with user input only if they enter...

excel

Jihad Al-Jarady
Mar 21, 2022
I got your point,
=IF(TRIM(B3)="",B3,"VLAN "&B3)
if you want to add the number in B3 between #( ), use this formula
=IF(TRIM(B4)="","","VLAN #( "&B4&")")

Jihad Al-Jarady

MCT

Mar 21, 2022

HI jharrisgray

This is the formula you need

=IF(TRIM(B3)="",B3,A3&" "&B3)

A3&" "&B3 this just to concatenate A and B and add space between them

jharrisgray
Copper Contributor
Mar 21, 2022
Thanks Jihad, that's close but if the user field is empty it marks this field with a 0. What I'd like is for the field with the formula to be blank if no user input is in B3, and if there is input in B3 I need it to read "VLAN" (B3) If that makes sense.
- Jihad Al-Jarady
  MCT
  Mar 21, 2022
  Use this one
  =IF(TRIM(B3)="","",A3&" "&B3)
  - jharrisgray
    Copper Contributor
    Mar 21, 2022
    Closer, I need to add to the formula where if there's entry in B3 it always read VLAN(B3) regardless of what text is entered in A3. So if A3 reads "Interface Vlan #" and B3 has a entry then I need to formula field to read "VLAN (B3)" currently with that formula it would read "Interface Vlan # (B3)"