Inconsistent calculated column formula

Question

I keep getting this error message pop up on my spreadsheet but it doesn't seem to fix itself once I click on the Restore Calculated Column Formula. Whenever, I do this and then sort within the table of calculated cells the problem reverts back.

sergeibaklan · Answer

arperez&nbsp;
That's not an error, that's alert, more about it here&nbsp;https://support.office.com/en-us/article/inconsistent-calculated-column-formula-5d2735ec-a8f2-4a06-a5f7-8b4352a4fa8d?ns=EXCEL&amp;version=90&amp;ui=en-US&amp;rs=en-US&amp;ad=US
You may ignore it.

arperez · Answer

SergeiBaklan&nbsp;Hey, thanks for your response.&nbsp; I noticed that the calculations were incorrect however so I can't ignore it.

mobiletim · Answer

arperez&nbsp;Hi, did you by chance figure this out. Mine just started doing this and not adjusting the formulas as it should, and has in the past. I'm sure it's a setting somewhere, but I can't figure it out.&nbsp;

Forum Discussion

Inconsistent calculated column formula

Share

Resources