Seems as though the problem is whether you were taught to use BODMAS or PEMDAS. As you can see, in BODMAS the division comes first and in PEMDAS the mult comes first. It depends upon which set of rules you were taught, and that seems to vary depending upon the location in the world you were taught math.
Exactly. I learned the mnemonic My Dear Aunt Susie in fifth grade, so I’d have said the answer is 1.
By the way, Excel calls it an invalid formula because of a cell reference error, whatever that means.