Can't cancel Inconsistent Calculated Column Formula message

**Ochimus** · 01-13-2019, 07:57 PM

Table has formula in G2 that requires the "hard" opening balance + income - expenditure to get the initial balance at the end of first day.
All subsequent rows are "Previous Balance + income - Expenditure" which generates the green flag as the Formula is inconsistent with the first one.

I can open the flag manually and select "Ignore Error", but cannot find the Code to do it automatically.

I tried

Please Login or Register  to view this content.

none of which worked.

Any solutions, suggestions or alternatives welcome as ever

**Richard Buttrey** · 01-13-2019, 08:02 PM

Please upload a workbook or a representative cut down copy, anonymised if necessary. It is always easier to advise if we can see your request in its context.

Show a before and after situation with manually calculated results, explaining which information is data and which is results, and if it's not blindingly obvious how you have arrived at your results some explanatory notes as well.