Forum Discussion
Simple Excel--WHAT has changed in new version?
A12 is the sum of Column A. B12 is the sum of Column B. The formula =Sum(A12+B12) returns 0. All cells are formatted as numbers. Can a cell containing a calculation no longer be referenced in the formula of another cell?
- Not sure why you're getting that result. I will say that, although it works and is often used that way, the SUM is redundant. =A12+B12 would suffice. I doubt, though, that that is the underlying issue. You can definitely continue to write formulas that refer to cells that themselves contain calculations. So something else is going on.
Is it possible for you to post a copy of the spreadsheet on OneDrive or GoogleDrive and paste a link here that grants edit access to it? Please do so.- Thank you. I started with =A12+B12. Also makes no difference if use + on keyboard or number pad. Have same issue with =A12*0.18 returning 0 while entering the value of A12 works, which is simply calculation of 2 numbers, not a calculated cell. Found a previous discussion by Minizv on July 13, 2022, with basically the same question and no solution.
I have the computer-based Home and Student version and get the message that my administrator has turned off the Help feature. I am the admin and did not turn it off???- How can synch be speeded up in OneDrive?
