Combine text and formula

  • Thread starter Thread starter charles
  • Start date Start date
C

charles

I'm trying to display text and the results of a formula. In this case, the
text comes first, and the formula result after.

Want the cell to read, "ROI = 4.99", with 4.99 the result of =quotient(N41,
C37)
 
="ROI ="&C37

--
If my posting was helpful, please click the "Yes" button.

ROCK ON!,

Scott
 
for some reason, the formula isn't recognizing N41/C37 as a calculation
(spoken as "value of cell N41 divided by value of cell C37"). That's why i
was trying the quotient function or "=quotient(N41,C37)". I had tried
N41/C37 and it wasn't flying.

As to the other ideas, thanks for jumping in, but none of the suggestions
tossed out by Pecoflyer or Mike have worked. Maybe they are close to
working, but i sure can't tell, lol

--
thanks,

charles


David Biddulph said:
How can 4.99 be the result of the QUOTIENT function? Perhaps you need to
remind yourself of that function in Excel help?
Did you perhaps intend to say N41/C37 ?
If you want to constrain the answer to 2 decimal places, then perhaps ="ROI
= "&TEXT(N41/C37,2)
Click to expand...
 
Wait, i understand what you are saying, 2 is the format of the value, meaning
this value to 2 decimal places. Excel isn't recognizing 2 as being a format
though. When i use that formula it comes back as "ROI = 2"
--
thanks,

charles


David Biddulph said:
How can 4.99 be the result of the QUOTIENT function? Perhaps you need to
remind yourself of that function in Excel help?
Did you perhaps intend to say N41/C37 ?
If you want to constrain the answer to 2 decimal places, then perhaps ="ROI
= "&TEXT(N41/C37,2)
Click to expand...
 
Yes!!!!!!!!
The correct way to do it:

="ROI = "&ROUND(N41/C37,2)

Have been ramming my head against the wall for hours now. Thanks so much!!!!
 
Back
Top