Using If with a blank option

I want to get the following result and I don’t know how to use the if function for that.

If (record is blank), CONCATENATE(a&b), CONCATENATE(b&c))

What should I do?
Thanks

What fields in the record are blank? If A, B, and C are fields in the record, then there would be nothing to concatenate. If they are not fields in the record, you don’t need a formula.

If you you have specific input fields that would be blank, and other fields that would not be blank, you can create an if statement with those.

IF( AND({Input 1} = BLANK(), {Input 2} = BLANK(), {Input 3} = BLANK())
  A & B,
  B & C
)
1 Like