Inconsistent Calculated Column Formula
This rule will identify any cells in a calculated table column that are different to the others in that column.
Smart Tag Menu
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.
When a formula in a calculated table column is different to the others in that column.
Enter the following data into cells "B2:C5".
Convert this range to a table using the Table command on the Insert Tab.
Enter the text "Total" into cell "D2".
The table will be automatically expanded to include this extra column.
Enter the formula "=B3+C3" into cell "D3".
The formula will be automatically expanded to the rest of the column.
Enter the number 10 into cell "D4".
© 2023 Better Solutions Limited. All Rights Reserved. © 2023 Better Solutions Limited TopPrevNext