Combine text and formula

[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)

 

[porter444]

="ROI ="&C37

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

ROCK ON!,

Scott

 

[Pecoflyer]

Hi, try ="ROI = "&quotient(N41,C37)

 

[Charles]

Actually this doesn't help. I don't need cell value, i need the result of a
formula

 

[Mike H]

Maybe

="ROI = "&QUOTIENT(N41, C37)

Mike

Actually this doesn't help. I don't need cell value, i need the result of a
formula

 

[David Biddulph]

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)

 

[Pecoflyer]

Maybe

="ROI = "&QUOTIENT(N41, C37)

Mike

Which looks a lot like my precedent post....

 

[Mike H]

Your point being?

Which looks a lot like my precedent post....

 

[Pecoflyer]

Take a gues

 

[Charles]

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

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)

 

[Charles]

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

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)

 

[David Biddulph]

Yes, sorry, I was asleep and stuck between two different solutions.
I should have said either
="ROI = "&TEXT(N41/C37,"#.00") or
="ROI = "&ROUND(N41/C37,2)
--
David Biddulph

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"

 

[Charles]

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!!!!