Correction......you wanted 0%

=IF(ISERROR(100%-I8),0,100%-I8)


Gord

On Fri, 19 Feb 2010 13:50:16 -0800, Gord Dibben <gorddibbATshawDOTca wrote:

You won't get #DIV/0! with that formula unless I8 is #DIV/0! to start with.

Correct the error in I8 would be my first step.

Or use this formula =IF(ISERROR(100%-I8),"",100%-I8)


Gord Dibben MS Excel MVP

On Fri, 19 Feb 2010 11:55:01 -0800, Elaine
wrote:

I am getting #Div/0! with the following formula.. I want it to display 0% in
the cell.

=100%-I8

Thanks!