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
|