Forum Discussion
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...
- 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&")")
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
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.
- Use this one
=IF(TRIM(B3)="","",A3&" "&B3)- 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)"
- 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&")")