Can I reference a hundreds value of a number from a cell in Apple Numbers?
For example, A1 has 12,345.00 I want A2 to output 345.00. Is this possible?
You can use the module function for this. In A2 enter
=MOD(A1;1000)
For example, A1 has 12,345.00 I want A2 to output 345.00. Is this possible?
You can use the module function for this. In A2 enter
=MOD(A1;1000)