Thread: Blank Cell
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Lester from AUS[_2_] Lester from AUS[_2_] is offline
external usenet poster
 
Posts: 6
Default Blank Cell

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