How do I get a formula result from one cell, reflecting in a sentence in another cell?

Posted on

QUESTION :

In Microsof Excel: How do I get the result of a formula, to reflect in a sentence? For example: I have a calculation in cell A1. Now in A2, I have the following sentence: “The result is…. and is reflected on the schedule of differences” . I want the result from A1 to reflect in this sentence where the …… is.

ANSWER :

You can use & to add strings and values together. For example:

= "The result is " & A1 & " and is reflected on the schedule of differences"

Leave a Reply

Your email address will not be published. Required fields are marked *