Why won't this work? =IFERROR(R2-D2)/R2," "

**Rooster35236** · 11-21-2010, 11:04 AM

=IFERROR(R2-D2)/R2," "

i'm trying to get rid of the DIV/0 on the blank spaces, Any help would be greatly appreciated

**Marcol** · 11-21-2010, 11:11 AM

Try this

=IF(ISERROR((R2-D2)/R2)," " ,(R2-D2)/R2)

**Rooster35236** · 11-21-2010, 11:15 AM

Thanks Marcol, now to help my understanding of excel functions why the nested iserror and why the redundant function at the end?

**Marcol** · 11-21-2010, 11:28 AM

An If statement has 3 arguements

IF(logical_test, value_if_true, [value_if_false])

You are testing:= ISERROR((R2-D2)/R2)

The value if TRUE is := ""

The value if FALSE is the tested function:= (R2-D2)/R2)

Use "help on this function" to see further.

Type =IF( in the formula bar then immediatly click the fx icon to the left, this gives you a function builder dialogue box, and direct access to help on this function.