25

I have the following IF condition in some cell:

=IF(A1>A2, "value is <C5>", "value is <D5>")

where <C5> and <D5> should be the values of cells C5 and D5.

I know it is a simple question but searching was not successful. I don't really know how to phrase this.

3
  • How about just =IF(A1>A2, C5, D5) Apr 28, 2014 at 14:22
  • @VidarS.Ramdal text is mandatory. cannot be omitted. I need something like: "value is %s, D5". don't know what the syntax is.
    – idanshmu
    Apr 28, 2014 at 14:24
  • Ah, of course. See answer below (in a second). Apr 28, 2014 at 14:25

1 Answer 1

42

You can use the string concatenation operator, &:

=IF(A1>A2, "value is " & C5, "value is " & D5)

This is equal to, but less verbose than:

=IF(A1>A2, CONCAT("value is ", C5), CONCAT("value is ", D5))

As to your follow-up comment, you can concatenate several strings and values:

=IF(A1>A2, "value is " & C5 & " right now, but could be " & D5, "value is " & D5 & " at the moment, but could be " & C5)

Also see Combining stuff in Google Spreadsheet

6
  • lovely. 10x a lot.
    – idanshmu
    Apr 28, 2014 at 14:32
  • BDW, what if I have multiple cell values that I want to insert in different places in the text?
    – idanshmu
    Apr 28, 2014 at 14:35
  • See revised answer. Apr 28, 2014 at 14:40
  • 2
    The & is clutch. Thanks for putting both versions, I knew exactly what was happening. Aug 24, 2016 at 23:34
  • That link for string concatenation doesn't mention anything about &. Please refer to the documentation for it. Great answer though.
    – Rishav
    Mar 16, 2021 at 17:14

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.