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

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

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

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

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

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" <(E-Mail Removed)> wrote in message
> news:9354BA96-167D-4C3E-8D9F-(E-Mail Removed)...
> > 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
>
>
>

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" <(E-Mail Removed)> wrote in message
> news:9354BA96-167D-4C3E-8D9F-(E-Mail Removed)...
> > 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
>
>
>

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" <(E-Mail Removed)> wrote in message
> news:9DC70330-B111-41B0-BF23-(E-Mail Removed)...
> > 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" <(E-Mail Removed)> wrote in message
> >> news:9354BA96-167D-4C3E-8D9F-(E-Mail Removed)...
> >> > 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
> >>
> >>
> >>
>
>
>