Thread: Separate Functions in One Cell

You can

This formaula displays the values of A1 & A2 in the one cell

=A1&" - "&A2

evanznotdead

I did not give a detailed answer previously as I thought you might be able to see how to join various rsults from my reply


Lets see if I can explain this in a way you can understand

To calculate/display left part of cells display
To display the value of B1 you use
=B1
The above could be any formula like =SUM(B1:B16)

To Display/Calculate the right side of the cell display
to display the result of B1-A1 you use
=B1-A1

As we can not use cell formatting to display the final result in the format required we use the text command, list the format required

=TEXT(B1-A1,"+$#,##0.00;-$#,##0.00")

To wrap the rsults in () we join text and the above formula using & symbol
="(" &TEXT(B1-A1,"+$#,##0.00;-$#,##0.00") &")"


Join Left and Right Cell Display FormulasNow we join the left and right parts together and also add a space in front of the ( to help seperate the 2 displayed values

=B1&" (" &TEXT(B1-A1,"+$#,##0.00;-$#,##0.00") &")"

Note:-
Change formating as required
"+0;-0")
Text formatting may also needed to be added to the left part of the formula