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

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

"Jim" wrote:

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

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

--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"Jim" wrote:

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

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

--
Anne Murray


"Jim" wrote:

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