This problem often arises because the cells containing the formula are formatted as 'text' instead of the 'General' type This could have occurred because either A text format has previously been applied to the cell; · As per Microsoft Excel behavior, when the cell type is a text then the calculation will not give expected result as number type for same number values In order to calculate the formula, the cell type needs to be number Please let us know if you have any other queries5 reasons why your Excel formula is not calculating, or not updatingThis video tutorial walks you through the different factors that can prevent an Excel fo
Autofill Copies Values Not Formulas
