Excel 2003 中的 IFERROR [英] IFERROR in Excel 2003

问题描述

我从阅读几个线程中了解到，Excel 2003 中的 IFERROR 是由 IF(ISERROR) 执行的.我试图从 Excel 2007+ 复制的代码是:

I understand from reading a couple of threads that IFERROR in Excel 2003 is preformed by an IF(ISERROR). The code I am trying to replicate from Excel 2007+ is:

=IFERROR(A1, "")

我知道必须有一个简单的解决方案可以将其转换为 IF(ISERROR)，但我没有成功.建议会很受欢迎.

I know there must be a simple solution to translating this to IF(ISERROR), but I have had no avail. Advice would be greatly received.

推荐答案

Excel 2003 中 =IFERROR(A1,"") 的等效项是 =IF(ISERROR(A1),"").请参阅 =IS.但该公式的两个版本都不是很有用.更有用的是 =IF(ISERROR(A1),0) ，其中 A1 中的错误，可能是由除以零引起的，在其他地方(即在带有公式的单元格)显示为 0.

The Excel 2003 equivalent of =IFERROR(A1,"") is =IF(ISERROR(A1),""). See =IS. But neither version of that formula is very useful. A little more useful would be something like =IF(ISERROR(A1),0) where an error in A1, perhaps resulting from dividing by zero, is elsewhere (ie in the cell with the formula) displayed as 0.

单个逗号的问题在于，如果 ISERROR() 为 false(即 A1 不是错误)，则返回 FALSE - 不是特别有用但相对混乱！

The trouble with the single comma is that if ISERROR() is false (ie A1 is not an error) this returns FALSE - not particularly helpful but relatively confusing!

所以这些公式通常与另一个公式一起使用，而不是 A1.也就是说，一个公式环绕另一个公式.更高版本的 Excel 可能具有 =IFERROR(A1/B1,"").因此，如果 A1 包含 1 和 B1 2，结果将是 0.5而如果将 A1 更改为 #REF!，则结果将为空白(在带有公式的单元格中不可见).更高版本是编写 =IF(ISERROR(A1/B1),"",A1/B1)(在更高版本中仍然有效)的简短方式 - 这是 Excel 2003 等效项.

So these formulae are normally used with another formula instead of A1. That is, one formula is wrapped around another. The later Excel version might have =IFERROR(A1/B1,""). Thus, if A1 contained 1 and B1 2, the result would be 0.5 whereas if A1 then were changed to become #REF! the result would be blank (nothing visible in the cell with the formula). The later version is brief way of writing =IF(ISERROR(A1/B1),"",A1/B1) (still valid in later versions) - which is the Excel 2003 equivalent.

这篇关于Excel 2003 中的 IFERROR的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！