I want to display an equation as text in a cell. I'll use an example to try to explain.
For example, Cell G7 is displaying "2.5" (without the quotes, of course)
I want to insert that "2.5" into another cell, G8 perhaps so that G8 will display this:
Y = $10,000 + $2.5X
I want to be able to automatically change the "2.5" to whatever the contents of the adjacent cell happens to be. The "Y = $10,000 + $" and "X" do not need to change. Is there a way to do this?
Last edited by bksmu; 09-20-2011 at 12:53 AM.
Hi,
How about G8
="Y = $10000 + $"&G7&" X"
Richard Buttrey
If this was useful then please rate it appropriately.
Click the small star iconat the bottom left of my post.
How do I delete this reply?
Excellent, Thank you Richard. However, now it is displaying the actual value of the cell I'm referencing, all 8 or 9 digits or however many. Can I force it to display only the number of decimals displayed in the referenced cell?Originally Posted by Richard Buttrey
What I have: Y = $10,000 + $1.3333333333X
What I want: Y = $10,000 + $1.33X
Hi,
The following will display 2 dec. places. Is that what you want?
="Y = $10000 + $"&TEXT(G7,"0.00")&" X"
Richard Buttrey
If this was useful then please rate it appropriately.
Click the small star icon
Jackpot, thanks again.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks