Help with clearing value of cell with 0 to clean up charts?

I have a main sheet with all my data. I have many sub sheets with charts for each row of data. I have the charts values linked to the main sheet so I don’t have to update the charts anytime we update the workbook for the next month.

Example Chart

Jan	Feb	Mar	Apr	May	Jun	Jul
0	0	78	75	76	77	79

Each value for the for the month is a linked cell
=Sheet1!F4
=Sheet1!G4
=Sheet1!H4
=Sheet1!I4
=Sheet1!J4
=Sheet1!K4
I wrote some code to change the value of 0 to null or nothing but it doesn’t seem to be working.

Please Login or Register  to view this content.

Any help is appreciated, thanks.

Thanks or the reply, I tried that earlier but it did not work either.

A co-worker already used this formula to achieve the same goal, I wish I would have asked before I wasted the time on the code.

=IF((Sheet1!F4<1),NA(),Sheet1!F4)

This actually puts in a #N/A instead of clearing the cell but it does get what I need.

Thanks for all your help.

SOLVED

=IF(Quality!E7<0.01,NA(),IF(Quality!E7="N/A",NA(), Quality!E7))