IF function return values: how to combine text with cells

[lookingforanswers1]

Hi all,

Most likely this is a super silly question (apologies in advance).

As you know the IF function compares two values, and returns either true or false.

What I want to do is to tweak the return portion, for example:

A1=1
B1=2

=IF(A1=B2, "No change", "Changed from A1 to B1")

On the 2nd return option, I don't know how to combine the text I want to have as an output, with the actual value of the cells. If the result is FALSE, I would like to have as an output "Changed from 1 to 2".

Is there a way in excel to do this?

Thanks

 

[Fluff]

Hi & welcome to MrExcel.
How about

=IF(A1=B2, "No change", "Changed from "&A1&" to "&B1)

 

[lookingforanswers1]

Hi & welcome to MrExcel.
How about

=IF(A1=B2, "No change", "Changed from "&A1&" to "&B1)

Perfect, I was trying everything using the $ sign instead the & !

Thanks!

 

[Fluff]

You're welcome & thanks for the feedback.