Apple numbers
how do I write a formula tp show 50% of a figure in a cell in a numbers spreadsheet?
MacBook Pro 13″, macOS 11.4
Question marked as
Top-ranking reply
Hi jray,
Several.
For the examples, the original value in in cell B2, and the formula is shown as you enter it in whatever cell is to hold the result.
50% of a value is half of that value, so you could use a simple division formula : B2/2
50% is also a way of exprssing the fraction 50/100.
The fraction can also be expressed as a decimal number: 0.50. so you could use a simple multiplication formula: B2*0.50
Or you could stick with the 'percentage' notation and write that multiplication formula as: B2*50%
All three will return the same result.
To enter the formulas, click on the cell that is to contain the formula, then type = to open the formula editor. Then type the formula as shown above into the editor. Click the green checkmark to confirm the formula and close the editor.
Note that Numbers will immediately change the division operator ( / ) to a division sign ( ÷ ) in the first formula,
and will automatically change the multiplication operator ( * ) to a multiplication sign (× ) in the second and third.
But Numbers will NOT recognize either if these signs if they are typed into the formula editor..
Regards,
Barry