| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Combine text and formula
Hi, try ="ROI = ""ient(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 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Combine text and formula
Maybe
="ROI = ""IENT(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 |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Combine text and formula
Mike H;117358 Wrote: Maybe ="ROI = ""IENT(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 |
|
#8
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Combine text and formula
Your point being?
"Pecoflyer" wrote: Mike H;117358 Wrote: Maybe ="ROI = ""IENT(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 |
|
#9
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#10
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#11
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#12
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#13
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I combine text and formula within the same cell? | Excel Discussion (Misc queries) | |||
| Combine text | Excel Discussion (Misc queries) | |||
| Combine text and formula? | Excel Worksheet Functions | |||
| Combine Formula and static Text | Excel Discussion (Misc queries) | |||
| Formula to combine text? | Excel Worksheet Functions | |||
Linear Mode
