Excel Formula Issue

%3CLINGO-SUB%20id%3D%22lingo-sub-2807293%22%20slang%3D%22en-US%22%3EExcel%20Formula%20Issue%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2807293%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20there!%3CBR%20%2F%3EI%20am%20completing%20a%20worksheet%20and%20m%20formula%20does%20not%20seem%20to%20be%20correct%2C%20although%20it%20does%20compute%20it.%3CBR%20%2F%3EI%20am%20getting%20an%20%22inconsistent%20calculated%20column%20formula%2C%22%20and%20I%20am%20not%20too%20sure%20what%20this%20may%20mean.%3CBR%20%2F%3EI%20know%20what%20numbers%20I%20must%20take%20to%20compute%20to%20solve%20for%20%22X%2C%22%20however%20I%20think%20I%20may%20be%20inputting%20the%20formula%20incorrectly%20to%20Excels%20standards.%3CBR%20%2F%3EThis%20is%20for%20an%20Income%20Statement%20and%20Balance%20Sheet.%3CBR%20%2F%3EPlease%20advise!%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2807293%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
New Contributor

Hi there!
I am completing a worksheet and m formula does not seem to be correct, although it does compute it.
I am getting an "inconsistent calculated column formula," and I am not too sure what this may mean.
I know what numbers I must take to compute to solve for "X," however I think I may be inputting the formula incorrectly to Excels standards.
This is for an Income Statement and Balance Sheet.
Please advise!

1 Reply

@sunique 

The error occurs because you have a formula in only 4 of the cells of the Actual Usage column, and it doesn't refer to cells in the same row.

Select I3.

Enter the formula =[@[Beginning Value]]+[@Purchases]-[@[Ending Value]]

Click the error triangle and select 'Restore to calculated column formula' from the popup menu.

Fill down from I3 to I46 (the last row of the table).

Also, you should not use SUM formulas in row 41. Delete the word Totals and the SUM formulas in that row.

Instead, activate the Table Design tab of the ribbon and tick the check box Total Row in the Table Style Options group.

This will add a new row to the table in row 47.

Click in the cell in row 47 of  each of the columns where you want a total, click the drop-down arrow in that cell, and select Sum from the drop-down menu.