IF statement, how to return a cells contents and a string.

[mlarmenta]

Hi All,

I'm cleaning a dataset and looking for no responses (blanks in the data). When there is no data in a given cell, I'd like to output:
A) the ID # associated with that row which is the contents of another cell in the same row
B) the string contents of another cell in the same column
C) the string "Blank"

This is an example:

IF(B2="", A2 B1 "Blank","").

If B2 is blank, then return the contents of A2 followed by B1 followed by the word, "Blank". Is it possible to return multiple values and strings and what is the proper syntax?

-mlarmenta

 

[sstiebinger]

IF(B2="",A2&B1&"Blank","")

you may want to add &" "& or &", "& to add spaces between a2 and b1

 

[JoeMo]

IF(B2="", A2&" "&B1&" Blank","")