Because of our arbitrarily designed (and, illogical, in my opinion) order of operations, this divisions is "left-to-right".

If you worked that out it would be =A1/product(A2:A10).

By the same "logic" the conseq subtractions becomes: A1-sum(A2:A10).

If the order was **right-to-left **(not backwards), like functions are (supposed) to be performed [ f(g(x)) you have to do g(x) first, the **right-most** function, then f of that ]

Somewhere along the line, it was forgotten that + - multiply and divide are ALL functions. They should behave like f(g(x)).

Well, had we done like that, the division would have provided alternating product and the subtraction would have been alternating sum -- both useful.

The way it's done has little or no use, I believe.

Somewhere along the line, it was forgotten that + - multiply and divide are ALL functions. They should behave like f(g(x)).

Oh well.

That's my math soapbox.