Inconsistent Calculated Column Formula

This rule will identify any cells in a calculated table column that are different to the others in that column.

alt text

Smart Tag Menu

alt text

Restore to Calculated Column Formula - Updates the formula so that it's consistent with the rest of the column.
Help on this Error - Displays the Help task pane.
Ignore Error - This removes the green triangle from the cell and the cell is no longer considered an error.
Edit in Formula Bar - Places the cursor into the Formula bar so it can be edited.
Error Checking Options - Displays the Options, Formulas Tab.


Example

When a formula in a calculated table column is different to the others in that column.
Enter the following data into cells "B2:C5".

alt text

Convert this range to a table using the Table command on the Insert Tab.

alt text

Enter the text "Total" into cell "D2".

alt text

The table will be automatically expanded to include this extra column.

alt text

Enter the formula "=B3+C3" into cell "D3".

alt text

The formula will be automatically expanded to the rest of the column.

alt text

Enter the number 10 into cell "D4".

alt text

© 2022 Better Solutions Limited. All Rights Reserved. © 2022 Better Solutions Limited TopPrevNext