Is it possible to display multiple values in the same cell? Column A - total fruit / Column B - total apples / Column C - total oranges / Column D - percentage or breakdown of apples/oranges, such as 40%- 60% or some variation... thanks
Is it possible to display multiple values in the same cell? Column A - total fruit / Column B - total apples / Column C - total oranges / Column D - percentage or breakdown of apples/oranges, such as 40%- 60% or some variation... thanks
Do you mean like this
=INDEX({"0-20%","20-40%","40-60%","60-80%","80-100"},MATCH(B2/A2,{0,0.2,0.4,0.6,0.8,1}))
Not quite that. If the total was 55 with 11 apples and 44 oranges, I would want to see 20 / 80, where the 2 values add up to 100%.
Something like:
=TEXT(B2/A2,"0%")&"-"&TEXT(C2/A2,"0%")
?
Yep! Thanks!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks