HI, In Excel there is the Text function converts a supplied numeric value into text, in a user-specified format.
I am trying to do the same in Numbers put there is not an equivalent function is there?
I am trying to bring the results of two separate calculation together into one cell, so far my best work around is to use an intermediary or hidden cell. I can do the two calculations separately then use something like = hiddencell1 & ” – ” & hiddencell2 which concatenates the cells retaining their specific formatting.
It works but is very clunky so I was wondering if there is a better way.
Thank you for your help.
I am trying to display the results of two separate calculations into one cell for example in Excel I will often show the value and its percentage, for example 10(9%).
—–
Ian
You just do it exactly as you are now, but with calculations. For instance:
=(B2+C2)&" - "&(D2+E2)
This will give you "5 - 99" if the result of B2+C2 is 5 and D2+E2 is 99.
If you want C2 to show the value of B2 and the percentage of how much B2 is out of column B, then something like this:
=B2&" ("&ROUND(100×B2÷SUM(B),0)&"%)"
I'm multiplying by 100 and then using round to get values like 18 instead of .187573627
Thank you, that is really helpful.