Forum Discussion
Excel now simplifies written formulas. Information is lost
Excel 365 application is simplifying formulas: I entered =(300/100)*(31/3) And after I click Enter the formula appears like this : =(3)*(10.333333) In that process I have lost information on h...
In that process I have lost information on how the formula was constructed. And in the future I will probably miss that information. I considered to be a drawback characteristic for a software made for precision.
In general it's not wise to do what's called "hard-coding of values" in the first place. If that term is new to you, here's a helpful reference with reasons not to do it.
Instead, assuming various cells contain values, such as
A1 contains 300
B1 contains 100
C1 contains 31
D1 contains 3
Then write the formula like this =(A1/B1)*(C1/D1)
and the construction of the formula is constant, even while different variables are used. You can always refer to the formula to see how it has used whatever values are in the four cells.