Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
displaying fractions in a concatenate formula
If I have a formula that concatenates text and numbers, for example, =concatenate("The average of ",A1," and ",A2," is = ",(A1+A2)/2) and I want the formula to display the "(A1+A2)/2" part as a fraction. The values in A1 and A2 will be integers. Can this be done in a non-VBA way? I'm using Excel 2003. Thanks in advance, Dave. -- DavidObeid ------------------------------------------------------------------------ DavidObeid's Profile: http://www.excelforum.com/member.php...fo&userid=2238 View this thread: http://www.excelforum.com/showthread...hreadid=564534 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
displaying fractions in a concatenate formula
DavidObeid Wrote: If I have a formula that concatenates text and numbers, for example, =concatenate("The average of ",A1," and ",A2," is = ",(A1+A2)/2) and I want the formula to display the "(A1+A2)/2" part as a fraction. The values in A1 and A2 will be integers. Can this be done in a non-VBA way? I'm using Excel 2003. Thanks in advance, Dave. ="The Average of"&A1&" "&A2&" "&"is= "&(a1+a2)/2 should work notice the spaces -- davesexcel ------------------------------------------------------------------------ davesexcel's Profile: http://www.excelforum.com/member.php...o&userid=31708 View this thread: http://www.excelforum.com/showthread...hreadid=564534 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
displaying fractions in a concatenate formula
="The Average of "&A1&" and "&A2&" "&"is= "&(A1+A2)/2 this could work better -- davesexcel ------------------------------------------------------------------------ davesexcel's Profile: http://www.excelforum.com/member.php...o&userid=31708 View this thread: http://www.excelforum.com/showthread...hreadid=564534 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
displaying fractions in a concatenate formula
Thanks, I tried it, but it didn't work. Here is (exactly) what I got after entering 3 in A1 and 4 in A2: "The Average of3 4 is= 3.5" -- DavidObeid ------------------------------------------------------------------------ DavidObeid's Profile: http://www.excelforum.com/member.php...fo&userid=2238 View this thread: http://www.excelforum.com/showthread...hreadid=564534 |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
displaying fractions in a concatenate formula
Thanks again, but now I get this: The Average of 3 and 4 is= 3.5 I'm still not getting the 3.5 to read as 3 1/2 -- DavidObeid ------------------------------------------------------------------------ DavidObeid's Profile: http://www.excelforum.com/member.php...fo&userid=2238 View this thread: http://www.excelforum.com/showthread...hreadid=564534 |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
displaying fractions in a concatenate formula
Use
="The Average of "&A1&" and "&A2&" "&"is = "& TEXT((A1+A2)/2,"# ??/??") You may want to use more ??? depending on what you want for the denominator. DavidObeid wrote: Thanks again, but now I get this: The Average of 3 and 4 is= 3.5 I'm still not getting the 3.5 to read as 3 1/2 -- DavidObeid ------------------------------------------------------------------------ DavidObeid's Profile: http://www.excelforum.com/member.php...fo&userid=2238 View this thread: http://www.excelforum.com/showthread...hreadid=564534 -- Dave Peterson |
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
displaying fractions in a concatenate formula
="The Average of "&A1&" and "&A2&" "&"is= "&TEXT(((A1+A2)/2),"#?/?") Okay I am getting closer I am now at 7/2 still working on the format -- davesexcel ------------------------------------------------------------------------ davesexcel's Profile: http://www.excelforum.com/member.php...o&userid=31708 View this thread: http://www.excelforum.com/showthread...hreadid=564534 |
#8
Posted to microsoft.public.excel.misc
|
|||
|
|||
displaying fractions in a concatenate formula
davesexcel Wrote: ="The Average of "&A1&" and "&A2&" "&"is= "&TEXT(((A1+A2)/2),"#?/?") Okay I am getting closer I am now at 7/2 still working on the format Oh, I see dave got it -- davesexcel ------------------------------------------------------------------------ davesexcel's Profile: http://www.excelforum.com/member.php...o&userid=31708 View this thread: http://www.excelforum.com/showthread...hreadid=564534 |
#9
Posted to microsoft.public.excel.misc
|
|||
|
|||
displaying fractions in a concatenate formula
Thanks! I got it :) -- DavidObeid ------------------------------------------------------------------------ DavidObeid's Profile: http://www.excelforum.com/member.php...fo&userid=2238 View this thread: http://www.excelforum.com/showthread...hreadid=564534 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Formula result not displaying in cell | Excel Worksheet Functions | |||
Dynamic Range with unused formula messing up x axis on dynamic graph | Charts and Charting in Excel | |||
CONCATENATE text formula | Excel Worksheet Functions | |||
How do you copy a cell formula down a column without displaying n. | Excel Worksheet Functions | |||
formula is displaying as text rather than result. | Excel Worksheet Functions |