Combine text and formula
 

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

Combine text and formula
 

="ROI ="&C37

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

ROCK ON!,

Scott


"charles" wrote:

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

Combine text and formula
 

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


--
Pecoflyer

Cheers
------------------------------------------------------------------------
Pecoflyer's Profile: http://www.thecodecage.com/forumz/member.php?userid=14
View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=32716

Combine text and formula
 

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

charles


"porter444" wrote:

="ROI ="&C37

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

ROCK ON!,

Scott


"charles" wrote:

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

Combine text and formula
 

Maybe

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

Mike

"Charles" wrote:

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

charles


"porter444" wrote:

="ROI ="&C37

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

ROCK ON!,

Scott


"charles" wrote:

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

Combine text and formula
 

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

Combine text and formula
 

Mike H;117358 Wrote:
Maybe

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

Mike

"Charles" wrote:

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

charles


"porter444" wrote:

="ROI ="&C37

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

ROCK ON!,

Scott


"charles" wrote:

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

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


--
Pecoflyer

Cheers
------------------------------------------------------------------------
Pecoflyer's Profile: http://www.thecodecage.com/forumz/member.php?userid=14
View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=32716

Combine text and formula
 

Your point being?

"Pecoflyer" wrote:


Mike H;117358 Wrote:
Maybe

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

Mike

"Charles" wrote:

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

charles


"porter444" wrote:

="ROI ="&C37

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

ROCK ON!,

Scott


"charles" wrote:

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

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


--
Pecoflyer

Cheers
------------------------------------------------------------------------
Pecoflyer's Profile: http://www.thecodecage.com/forumz/member.php?userid=14
View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=32716

Combine text and formula
 

Take a guess


--
Pecoflyer

Cheers
------------------------------------------------------------------------
Pecoflyer's Profile: http://www.thecodecage.com/forumz/member.php?userid=14
View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=32716

Combine text and formula
 

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

Combine text and formula
 

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

Combine text and formula
 

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

Combine text and formula
 

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