Forum Discussion

Craig Barnes's avatar
Craig Barnes
Copper Contributor
Jun 27, 2018

copied formulas not computing properly in excel

When I copy a formula to another line it instead shows the result of the formula copied. Example:

 

I copy =SUM(A1/B1) to line below. Even though this entry on the second line reads =SUM(A2/B2) the result it shows is the calculation A1/B1. Once I click on the formula and then click on A2 or B2 it corrects itself and shows the result A2/B2. I've never had this issue before but it happens with every formula I try to copy. Please help!

excel
Formulas and Functions
office 365
  • SergeiBaklan's avatar
    SergeiBaklan
    MVP
    Jun 27, 2018

    Hi Craig,

     

    Please be sure your calculate options (Formulsa->Calculate options) is set to Automatic. Default setting is in File->Options->Formulas

Resources