On Mar 21, 2:58 am, Lester from AUS
wrote:
Hello Exceller',
I am trying to convert a cell to a blank based on an IF argument. I have a
graph reading off this cell and I want it to be read as a blank cell. I am
using the following formula =IF(C180.1,C18,""), however while the cell
appears blank the graph is still reading this cell as "0" and creating the
line graph to zero.
Thank you for any assistance

Try formula:

=IF(C180.1,C18,NA())

Regards
--
Mladen
http://excelancije.bloger.hr