Numbers division error when dividing with a calculated value

What is going on is that 100000 * 70000 / 60000 = 116666.666666667.

You may display 6/7 as .86, but in reality, the value is 0.857142857142857. The complete value is used for the subsequent calculations.

If you really want to use 0.86, then you have to use FIXED

FIXED(6/7,2) = 0.86

I'd use ROUND(6/7,2) instead of FIXED.

FIXED returns a string (text, not a numerical value).

ROUND returns a number (which is more often what is intended).

When there is ambiguity Numbers is reasonably good at guessing what you mean. Though in general multiplying a number by a string/text doesn't work, Numbers should let you multiply the result of the FIXED formula that looks like a number by another number, for example. But it's generally not a good idea to make Numbers guess unless you have to.

FIXED is more often used to put a correctly formatted "number" within a longer piece of text or string all in one cell. Even then you can easily achieve the same effect with ROUND.

Note that you cannot format a cell with FIXED as Currency (cell B3 in the screenshot) but you can with a cell with ROUND (cell B4). As a result, if using FIXED you have to insert an extra $ (or other currency symbol) when putting together a string (A7, vs A8 in the screenshot have the formulas, with the results in column C).

Net, net, you might want to consider using the more common ROUND rather than FIXED, unless you encounter a special situation where FIXED works better. (I can't think of any right now, but there might be some.)

SG

Fun fact. There are lots of other rounding functions in Numbers aside from ROUND and FIXED, among them MROUND, ROUNDDOWN, ROUNDUP, FLOOR, CEILING, EVEN, ODD.

If you want to overcharge, there are choices for you. If you want to undercharge, there are choices there too!

See this in the Numbers User Guide: Rounding functions.

SG

Yes of course ROUND, I had a memory blank when I suggested FIXED.

But think carefully before using either. In 99% of the cases, the result you need is 116666.67, not 116279.07. It's best to carry as many decimals as possible as far as possible in the chain of formulas. Imagine if that result is land area and you then use it to calculate property tax. You certainly don't want to undercharge or overcharge, depending on how the rounding goes.