Question

The Formula in cell A2= B2 + C3. On Copying the formula to cell C2 what will be the formula? ​

Answer 1

Answer:

C2 =D2+E3

Explanation:

As per given question statement, we are given a formula for a cell A2;

A2 is =B2+C3

Now if we copy this A2 formula to a new cell C2, the new formula in C2 becomes as D2+E3 when we select the normal option of paste( Paste P option) in excel.

Excel gives multiples options when pasting a field, like simple paste, keep source formatting, formula etc.