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

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

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

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

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

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

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

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

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