为什么我的公式显示错误-MS Excel中计算列公式不一致? [英] Why my formula is showing error - Inconsistent calculated column formula in MS Excel?

问题描述

我的公式显示错误:计算列公式不一致.但是它的工作和返回结果仍然符合预期.

My formula is showing error: Inconsistent calculated column formula. But still its working and returning result as expected.

公式:

=IF(B7="","",IF((MINUTE(M7))>=15,TRUNC(HOUR(M7)+MINUTE(M7)/60)+1,TRUNC(HOUR(M7)+MINUTE(M7)/60)))

我正在使用Microsoft Office2007.请帮忙.

I'm using Microsoft Office 2007. Please help.

推荐答案

这是因为前一行/列上的公式有些不同.

That's because the formula on the previous row/column is a bit different. This is what Microsoft says about it:

Excel表中的计算列是有效输入公式的绝佳工具.它们使您可以在一个单元格中输入一个公式，然后该公式将自动自动扩展到该列的其余部分.无需使用填充"或复制"命令.这可以节省大量时间，尤其是当您有很多行时.当您更改公式时，也会发生同样的事情.更改还将扩展到计算列的其余部分. 计算列可以包含一个单元格，该单元格具有与其他单元格不同的公式.这将创建一个异常，该异常将在表中明确标记.这样，可以很容易地检测到并消除意外的不一致.

Calculated columns in Excel tables are a fantastic tool for entering formulas efficiently. They allow you to enter a single formula in one cell, and then that formula will automatically expand to the rest of the column by itself. There’s no need to use the Fill or Copy commands. This can be incredibly time saving, especially if you have a lot of rows. And the same thing happens when you change a formula; the change will also expand to the rest of the calculated column. A calculated column can include a cell that has a different formula from the rest. This creates an exception that will be clearly marked in the table. This way, inadvertent inconsistencies can easily be detected and resolved.

这篇关于为什么我的公式显示错误-MS Excel中计算列公式不一致?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！