I understand why Excel is doing this as per this document
, but I want to change the calculation order to not be a negative as I want it treated as an operator i.e. a minus.
2/4-3+9*6 = 51.5 according to Excel and Google treated as (2/4)-3+9*6 I think.
I however want it to calculate like this:
Division First = 2-3+9*6
Multiplication Second = 2-3+54
Addition Third = 2-57
Subtraction Last = -55
Any way I can change this behaviour with a custom function or indeed something else?