Value if an if statement is false
 

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)

Value if an if statement is false
 

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)

Value if an if statement is false
 

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" 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)

Value if an if statement is false
 

Thank you so much

"Mike H" wrote:

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" 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)