Forum Discussion

jharrisgray's avatar
jharrisgray
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 a value in a different field.  I also need this field to populate text that I enter in the formula only if the user puts a value into the original field.  Below is a example:

 

 

excel
  • Jihad Al-Jarady's avatar
    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&")")

8 Replies

    • jharrisgray's avatar
      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.

Resources