lookingforanswers1
New Member
- Joined
- Mar 24, 2021
- Messages
- 2
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
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