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

--
thanks,

charles


"David Biddulph" wrote:

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

"Charles" wrote in message
...
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" wrote:

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

"charles" wrote in message
...
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)

--
thanks,

charles