Oct 07 2021 05:18 AM
At the moment, I've got:
=IF(B27<>"","I want to show this sentence with ("B27") in the middle of it.","")
Obviously the ("B27") is wrong and here I want the actual text that's written in B27.
Any ideas? Thank you so much!
Oct 07 2021 05:40 AM
Like this:
=IF(B27<>"","I want to show this sentence with (" & B27 & ") in the middle of it.","")