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)