Take the 2-minute tour ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

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.

share|improve this question

1 Answer 1

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

= "The result is " & A1 & " and is reflected on the schedule of differences"
share|improve this answer
1  
Depending on how you want to show the number you might also need TEXT, FIXED or ROUND function around A1 e.g. for 2 decimal places FIXED(A1,2) –  barry houdini Apr 9 '13 at 16:19

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

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