Combining text and calculation

  • Thread starter Thread starter Michael Dobony
  • Start date Start date
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
 
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.
 
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...
 
Back
Top