![]() In our example, the formula becomes A4*B4 to match the pattern A3*B3 in the cell above. Make the formula consistent by copying the pattern from the cell above. The shortcut menu shows the options that are available to resolve this warning. ![]() If the next formula after A3*B3 is A4*B2, Excel identifies it as an inconsistent formula, because to continue the pattern, the formula should be A4*B4.Ĭlick the cell that contains the error indicator and look at the Formula Bar to verify that cell references are correct.Ĭlick the arrow next to the button that appears. If the formula is wrong, making the cell reference consistent often solves the problem.įor example, to multiply column A by column B, the formulas are A1*B1, A2*B2, A3*B3, and so on. This does not always mean that the formula is wrong. An error indicator appears when the formula does not match the pattern of other formulas near it.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |