Iserror help

Jim · Dec 11, 2008

Hello,

I have the basic is error formula (=IF(ISERROR(AC21),"",AC21))
What I need help with is in cases where the formula is referencing a cell
that has 0 or blank; how do I write the formula where it will return nothing
if these two items appear?

Thank you

Sheeloo · Dec 11, 2008

Try
=IF(ISERROR(AC21),"",IF(AC21=0,"",AC21))

Luke M · Dec 11, 2008

=IF(OR(AC21=0,ISERROR(AC21)),"",AC21))

FinRazel · Dec 11, 2008

IF(ISERROR(AC21),"",IF(OR(ISBLANK(AC21),A1=0),"",AC21))

IF question	4	Aug 10, 2007
iserror problem	9	Oct 11, 2013
=IF(ISERROR(VLOOKUP(A3,contacts!B:I,5,FALSE)), " ", VLOOKUP(A3,con	4	Feb 2, 2010
=IF(ISERROR(VLOOKUP(F2,Content_Insert!A:A,1,0)),"",VLOOKUP(F2,Mast	3	Jan 26, 2010
nested formulas in excel using iserror and if	2	Jun 4, 2010
adding =if(iserror to formula	6	Aug 27, 2009
IF(ISERROR problem	6	May 21, 2009
Iserror - too many arguments	2	Jul 1, 2009

Iserror help

Jim

Sheeloo

Luke M

FinRazel

Ask a Question

Similar Threads