You can concatenate any number of cell references and text by using the
ampersand (&).

I.E. =IF(A12=4, "MDL=" & B12, "value if false")



"kpt" wrote:

I need to know if there is a way that when an if statement is either true or
false the value returned can contain a mixture of text and a cell reference.
Example =IF(A12=4,"Mdl =" cell reference here, value if false)