In a Numbers spreadsheet, is it possible to format a cell to include a label as well as calculated value or formula? Say I like to have a cell for interest rate that multiple rows or columns reference for sensitivity calculations. Can I have that cell show: "Interest Rate: 10%” where the number is a calculated value?
MacBook Pro (2021)
Ali Soltani wrote:
Can I have that cell show: "Interest Rate: 10%” where the number is a calculated value?
Yes. In the Format sidebar, section Cell, create a personalized format that includes the text. Use Scale (K) to introduce the percentage.
So the cell shows Interest Rate: 10% but in reality it's just the value 0.1 that can be used in other cells' formulas, as you can see in the status bar at the bottom of the window.
Say cell A1 has the value 10%
Cell A2 formula could be ="Interest Rate: "&A1
Or say cell A1 has the value 50 and A2 has the value 5
Cell A3 formula could be ="Interest Rate: "&A1/A2&"%"
Both would result in Interest Rate: 10%
You could also do it with a custom cell format.
Thanks for the tip - it mostly worked, except that the interest rate that was calculated in the same cell was 2/3 of 1% ("DRC: "&2÷3&"%"), which showed as “Interest Rate: 0.666666666666667%”. I tried setting the format to Percentage & limit the decimals but it remained at Automatic. The only way I could make the cell show fewer decimals was to calculate the figure in another cell, format it, & reference it, just as your first example. So is there a way to limit the number of decimals & still do the calculation in the same cell which is labeled as Interest Rate?
Use ROUND.
="DRC: "&ROUND(2/3,2)&"%"
Can a cell in OSX Numbers include a text/label as well as a calculated value?
