Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
text in a formula?
Hi, first post here...looking to show a conversion ratio in my formula
results ona spreadsheet. I want the results formatted to show Ex: 1 in 90, where the 90 is calculated by a formula and "1 in" is text. Please assist :) Thanks! |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
text in a formula?
=concatenate("1 in ",[your formula]).
The concatenate function joins two strings together, in this case, a text string and a claculation. Example: =CONCATENATE("1 in ",(A1/B1)) would return [1 in (A1/B1)] where A1/B1 is your calculation. Make sure that the "1 in ", part of your function is exactly as I put it above, otherwise you'll either get an error, or else, will have spacing issues between the "1 in" part and the calculation. Dave -- Brevity is the soul of wit. "CD13" wrote: Hi, first post here...looking to show a conversion ratio in my formula results ona spreadsheet. I want the results formatted to show Ex: 1 in 90, where the 90 is calculated by a formula and "1 in" is text. Please assist :) Thanks! |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
text in a formula?
Maybe you could modify your existing formula to look like:
="1 in " & yourexistingformula or ="1 in " & text(yourexistingformula,"#,##0.00") if you need formatting. You could also use Format|cells|Number tab|custom category: "1 in "General or "1 in "#,##0.00 (if you always have non-negative numbers) The first method (modifying the formula) will result in a text string in the cell. The second method will keep the value a number--but will make the display look the way you want. CD13 wrote: Hi, first post here...looking to show a conversion ratio in my formula results ona spreadsheet. I want the results formatted to show Ex: 1 in 90, where the 90 is calculated by a formula and "1 in" is text. Please assist :) Thanks! -- Dave Peterson |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
text in a formula?
Something like....
="1 in " & B1/A1 HTH "CD13" wrote: Hi, first post here...looking to show a conversion ratio in my formula results ona spreadsheet. I want the results formatted to show Ex: 1 in 90, where the 90 is calculated by a formula and "1 in" is text. Please assist :) Thanks! |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
text in a formula?
="1 in "&A1
where A1 is the cell with the computed 90 But if the value is not exactly 90 (maybe 90.05 but displayed as 90) you will need ="1 in "&TEXT(A1,"#") best wishes -- Bernard V Liengme www.stfx.ca/people/bliengme remove caps from email "CD13" wrote in message ... Hi, first post here...looking to show a conversion ratio in my formula results ona spreadsheet. I want the results formatted to show Ex: 1 in 90, where the 90 is calculated by a formula and "1 in" is text. Please assist :) Thanks! |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
text in a formula?
Thanks for the assistance everyone! I got it to work. Take care.
CD "Bernard Liengme" wrote: ="1 in "&A1 where A1 is the cell with the computed 90 But if the value is not exactly 90 (maybe 90.05 but displayed as 90) you will need ="1 in "&TEXT(A1,"#") best wishes -- Bernard V Liengme www.stfx.ca/people/bliengme remove caps from email "CD13" wrote in message ... Hi, first post here...looking to show a conversion ratio in my formula results ona spreadsheet. I want the results formatted to show Ex: 1 in 90, where the 90 is calculated by a formula and "1 in" is text. Please assist :) Thanks! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Invisable text in formula bar | Excel Discussion (Misc queries) | |||
Convert text to formula - Help pleaaase | Excel Discussion (Misc queries) | |||
Formula Being treated as Text | Excel Worksheet Functions | |||
Formulas dealing with text data | Excel Worksheet Functions | |||
Using the text from a cell as a range name in a formula | Excel Discussion (Misc queries) |