Reference a cell mid sentence.

[AdamWest]

Hello.

I was wondering if there is a way to reference a cell in the middle of a sentence. I have a spread sheet with three variable that will change from time to time. I would like to make a statement on my sheet that describes my data using the three variables in the sentence. So this is what my sentence will say: "Dollar amount is based on a 12 hour day and a 25 day month with a kWh rate of .13.

12, 25, and .13 are the variables. When I change those variables I would like the sentence to update and use the new variables. Is there a way that this can be done? Any help would be great. TIA!

 

[Juan Pablo González]

Put in A2, A3 and A4

12
25
0.13

and in B1 put

="Dollar amount is based on a " & A2 & " hour day and a " & A3 & " day month with a kWh rate of " & A4 & "."

 

[AdamWest]

That did the trick. Thank you so much that made my day.