Iferror help needed

I am using a formula in B1 =IFERROR(A1*5,"").
When A1=0, i want the result in B1 as blank. How to do this?

Maybe:
=IF(OR(A1=0,ISERROR(A1*5)),"",A1*5)

=if(a1=0,"",A1*5)


or as the previous post says, it depends if 0 was considered the error, or additional to the error
=IF(OR(A1=0,ISERROR(A1*5)),"",A1*5) might be reduced to =IF(OR(A1=0,ISERROR(A1)),"",A1*5) as unless text appears in the cell it would not cause an error


or you can format to make 0 appear as blank. choose a custom format and type 0;-0;;@

Originally Posted by davsth

=if(a1=0,"",A1*5)
ustom format and type 0;-0;;@

Thanks it solved.

Originally Posted by bebo021999

Maybe:
=IF(OR(A1=0,ISERROR(A1*5)),"",A1*5)

Thank you.