If then statement with text and cell reference

**Jhertilus** · 10-19-2016, 04:56 PM

I'm trying to write an if/then statement

=IF(A=1,"Your score was value of cell a2,"Your score was value of a3")

How do I include the value of a specific cell into an if/then statement that also contains text?

**Tony Valko** · 10-19-2016, 05:00 PM

Maybe this...

="Your score was value of "&IF(A1=1,A2,A3)

**Jhertilus** · 10-19-2016, 05:17 PM

Worked, thank you!

**Tony Valko** · 10-19-2016, 05:40 PM

You're welcome. Thanks for the feedback!

If then statement with text and cell reference

LinkBack

Thread Tools

Rate This Thread

Display

If then statement with text and cell reference

Re: If then statement with text and cell reference

Re: If then statement with text and cell reference

Re: If then statement with text and cell reference

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] Sumifs reference criteria is text but I want to reference cell

Indirect Sheet reference with cell reference left function and text

How to reference text in specific cell in an If statement

How to use a cell reference in a text statement

[SOLVED] Convert If statement with cell row reference calculations to vlookup statement

Cell-Reference in a text-statement within an excel-worksheet

Text Cell reference and increase the cell reference by step value

Bookmarks

Bookmarks

Posting Permissions