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.

       

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

        Szpilman 

        Perhaps you may generate and share sample file to illustrate an issue?

Resources