Formula Putting a Zero in front of contact name

taylor.thompson89836

I am using a basic if statement to try to populate contact emails into a column.

=IF([Business Unit]@row = "Field", "email1") + IF([Business Unit]@row = "Home Office", "email2") + IF([Business Unit]@row = "Distribution", "email")

Whenever the option is Distribution though, it puts a 0 in front of the result

Does anyone know what would be causing this?

Leibel S

Try adding to the false option an empty string:

=IF([Business Unit]@row = "Field", "email1","") + IF([Business Unit]@row = "Home Office", "email2","") + IF([Business Unit]@row = "Distribution", "email","")

Leibel S

Try adding to the false option an empty string:

=IF([Business Unit]@row = "Field", "email1","") + IF([Business Unit]@row = "Home Office", "email2","") + IF([Business Unit]@row = "Distribution", "email","")

taylor.thompson89836

Such a silly error! Thank you, that worked!