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()为假(即 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屋！