If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#31
|
|||
|
|||
Getting #DIV/0!, how to get 0%?
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! |
Thread Tools | |
Display Modes | |
|
|