Forum Discussion

Szpilman's avatar
Szpilman
Copper Contributor
May 23, 2023

What is wrong with my Excel?

I have a very weird issue with Excel lately and I'm wasting lot's of time.   Yesterday, I had to make a spreadsheet to calculate some oscillations. I made some columns with values and some columns ...
excel
Formulas and Functions
office 365
SergeiBaklan's avatar
SergeiBaklan
Diamond Contributor
May 23, 2023

Szpilman 

Could you please check if you are in Automatic calculation mode, not Manual one

  • Szpilman's avatar
    Szpilman
    Copper Contributor
    May 23, 2023

    Thanks for your reply. Unfortunately it's not the solution. I checked and the automatic calculation mode is already on.

    • SergeiBaklan's avatar
      SergeiBaklan
      Diamond Contributor
      May 23, 2023

      Szpilman 

      May I clarify. You have some numbers in B5,E5,D5 and B6,E6,D6. Doesn't matter they were entered manually or calculated by formula.

      and formula

      =B5*SIN(RADIALEN(E5*D5))

       somewhere in row 5. 

      You copy above formula and paste it to the cell down, which gives

      =B6*SIN(RADIALEN(E6*D6))

      Result is the same as in above, correct?

       

      One more question. If Formulas->Error checking->Circular reference, do you see one?

       

       

      • Szpilman's avatar
        Szpilman
        Copper Contributor
        May 23, 2023

        SergeiBaklan 

         

        Shortly: Yes, the result is the same for =B5*SIN(RADIALEN(E5*D5)) and =B6*SIN(RADIALEN(E6*D6))

        (btw: These formula is in column H)

         

        It's even get stranger now:

        If I remove the formula in column D and replace it manually by typing the values, I get a right answer in the column H (and after removing the radians like below:) formula B6*SIN(RADIALEN(E6*D6)), B5*SIN(RADIALEN(E5*D5)), ....

         

        However, if I use the values in column D created by a formula, the output shows a totally wrong answer. If I add the radians, it shows the right answer for the first cell. The others which are copied down in col. H are just exact the same value, which is imossible due to changing values in column E and D.

         

        I also checked it with my graphical calculator all the time. 

         

        - I don't see circular reference under Error checking.

         

Resources