Iserror help
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
|