Question

Mudit wants to calculate the total of the values in cells B1, B2, and B3.
He has written the formula B1 + B2 + B3 in cell B4. But he did not get the
required answer.
i. What is wrong with the formula entered in cell B4? How will you correct it?
ii. If he changes the value in any of the cells B1, B2, or B3, will that affect the
value ​

Answer 1

Answer:

(i) =SUM(B1+B2+B3)

(ii) Yes, If he changes the value in any of the cells B1, B2, or B3, that will affect the sum value