Question

What happens if we makes the corrections in the data after typing formula ? Do we need to type the formula again or there is some facility in MS-excel to avoid retyping

Answer 1

Explanation:

When you set the cell formatting to “Text”, Excel treats the formula as text and shows it instead of evaluating it. To fix this error, just select the cell, set its formatting to “General”. Now edit the formula and press enter. (Alternatively you can press F2 and then Enter after setting format to General).

Answer 2

Answer:

I hope answer is helpful to us