Value if an if statement is false

[kpt]

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)

 

[Christopher Robin]

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

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

 

[Mike H]

Hi,

I don't understand your example but the answer is yes you can have a mixture
of text and a cell reference, you do it with the & (ampersand) sign

=IF(A12=4,"Mdl =" & A13, "Something else")

Mike

 

[kpt]

Thank you so much

Hi,

I don't understand your example but the answer is yes you can have a mixture
of text and a cell reference, you do it with the & (ampersand) sign

=IF(A12=4,"Mdl =" & A13, "Something else")

Mike