You may have run into the issue where the Excel formulas are displayed in the cell instead of the result of the formulas. As you know, by default when you start the contents of a cell with an equal sign, Excel will treat the values entered into the cell as a formula, and will perform the calculation and show the result.
However, as mentioned, you may experience the issue where the formula doesn’t appear to be calculated, and instead is displayed as text in the cell. There could be a few reasons why this is so, and this post explains how to correct the issue where the Excel formulas are displayed in the cell.