I am struggling with a really simple formula.
I have a gross figure in one cell and need the next cell to have a deduction of 20%
I also can't seem to find the star symbol I have seen MAC numbers people using??? My forward slash symbol has also turned into a divide symbol?
if the gross value is in cell A1, then the formula would be:
=A1*0.8
the star symbol is the asterisk (shift + 8)
if the gross value is in cell A1, then the formula would be:
=A1*0.8
the star symbol is the asterisk (shift + 8)
The star (asterisk) gets converted into an x in Numbers. The / symbol gets converted into the divide symbol that looks so much like a + that it is easy to mistake it for one. Both are new to this version of Numbers. I suppose it was done for looks but it wasn't a great idea in my opinion.
Hi Vicky,
In Numbers 3, the slash sign is converted to the divide sign.
Formula in D2 was entered as =B2/2
Numbers 3 converts that to
=B2÷2
Or to give more clarity with a larger font,
=B2÷2
(dot over line over dot).
Formula in D3 was entered as
=B3*C3
Numbers 3 converts * to x
=B3×C3
Badunit wrote:
"I suppose it was done for looks but it wasn't a great idea in my opinion."
Seconded. Very childish.
Regards,
Ian
Thank you all sorted now.
It was the symbols that were confusing me, once this had been explained I managed the formula no problem.
Percentage formula in numbers
