Combining text and calculation

M

Michael Dobony

I have a formula in a cell, =ABS(C5-D5)/C7. How do I add text to the
calculation? I want the following displayed in the cell:

d = 1.5
 
P

Pecoflyer

Michael said:
I have a formula in a cell, =ABS(C5-D5)/C7. How do I add text to the
calculation? I want the following displayed in the cell:

d = 1.5
Click to expand...

Try ="d = "&ABS(C5-D5)/C7

--
Pecoflye

Cheers -
*'Membership is free' (http://www.thecodecage.com)* & allows fil
upload ->faster and better answers

*Adding your XL version* to your post helps finding solution faste
 
K

Kevin B

You can create a custom format using the following format mask:

"d = "###.0

By using a format mask the cell retains the value and it can be using in
other calcuations.
 
A

Alojz

nice!

Kevin B said:
You can create a custom format using the following format mask:

"d = "###.0

By using a format mask the cell retains the value and it can be using in
other calcuations.
Click to expand...
 
Top