Two Value formulas in one cell?

[Pc1x1]

Is it possible to put two independent sum formulas?

IE. =Sum(A1*1/4)&"/"&Sum(A1*1/2)

If I Concatenate it adds, I want both seperate or do I have to use separate cells. I realize this is a bit awkward, but was hoping there exists a separator value I am not aware of. Thanks.

 

[mikerickson]

Seperate cells would probably be wisest.
You could make white borders and format the right cell with "/"#.# to make it visualy pleasing.

 

[Ruddles]

Am I missing the point here? If you concatenate those values, Excel doesn't add them, it concatenates them. I get:-

<TABLE style="WIDTH: 71pt; BORDER-COLLAPSE: collapse" border=0 cellSpacing=0 cellPadding=0 width=95><COLGROUP><COL style="WIDTH: 71pt; mso-width-source: userset; mso-width-alt: 3474" width=95><TBODY><TR style="HEIGHT: 15pt" height=20><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent; WIDTH: 71pt; HEIGHT: 15pt; BORDER-TOP: windowtext 0.5pt solid; BORDER-RIGHT: windowtext 0.5pt solid" id=td_post_2756784 class=xl65 height=20 width=95>

0.25/0.5​

</TD></TR></TBODY></TABLE>

Also, question: why are you using SUM formulae when you're not summing anything?

You can separate them with almost any character - a space, for example.

What are you actually trying to do? Just show the results of two formulae in a single cell?

 

[Ruddles]

(I hate it when I don't understand something and everyone else seems to!)

 

[Scott Huish]

Concatenation doesn't add, it just appends to the string. Your formula should work, although as is already pointed out, you don't need SUM. Also multiplying by a fraction is the same as dividing by its reciprocal.

=A1/4 & "/" & A1/2

Excel Workbook
	A	B	C
1	12		3/6
Sheet1

http://www.excel-jeanie-html.de/index.php?f=1

 

[Ruddles]

Also multiplying by a fraction is the same as dividing by its reciprocal.

Yes, or to put it another way, A1*1/4 is the same as A1*1 divided by 4.

 

[Pc1x1]

You guys are right =CONCATENATE does work, however I thought it was adding because its giving me a strange value. Excell isn't following the rules of adding, I need to multiply the value in A1 by a fraction, and I put it in A1*(#1/#2), but its giving me a value as if A1*#1 then Divide it by #2.

Thanks, getting close

Got it, I believe Excel, was auto adding a line in there, that I mistyped and it was throwing it off, redid it by hand, and it works, thanks guys.