errors and zeros

I have an excel spreadsheet with multiple tabs. When I enter a formula in one of the tabs which performs a calculation across two or more of the other tabs, I sometimes will get a zero or an error. How can I use the iferror formula (or another function) to turn both these two possible results to a blank cell leaving me with just values other than zero or error ?

encode ur formula with iferror at start =iferror(ur formula),blank)
=iferror(()," ")

This does not remove both #error and "0"

for instance, if the formula =IFERROR('TAB1'!DU283/'TAB2'!DU283,"") is written, This changes an #error to blank but if the result is zero, then the zero is placed in the cell

I'm still getting #value! and #div/0!. The zeros have changed to blank though.

Hi again, I still cannot get the formula to work. I've attached a demo file trying to show what I'm doing. The results in cells G13 and G14 should be blank but they are showing #value! and #div/0! What am I doing wrong ?

Hi,

In G12: =IFERROR(G5/G8,"")
G13: =IFERROR(G4/G10,"")
G14: =IFERROR(G5/G9,"")

Hi, I want cell to only return a value if result is NOT 0, or #div/0! or #value! or any other error code

Did you try the formula I suggested?

Hi,

As you want to remove zeroes as well, try this:

Formula:

Please Login or Register  to view this content.

I tried using OR instead of two nested IF statements, but for some reason that doesn't work - but the formula above works for me - see attached file.
Remove zeros and errors.xlsx

Regards,
Aardigspook

If your problem is solved, please go to 'Thread Tools' on your first post and 'Mark Thread as Solved'.
You don't need to give me rep if I helped, but thanks are appreciated.

Thank you Soooooooo Much! Problem solved.

You're welcome.