Blank Cell Function

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Is it possible to create a "blank" cell (similar to a cell whose contents have been deleted) in Excel using a function of some sort? A BLANK function that can be used like

=IF(A1<0,BLANK,1

Using functions such as =IF(A1<0,,1), or =IF(A1<0,"",1) create a problem when graphing because the "blank" cell is graphed as zero. There is also nothing on the Tools>Options>Charts dialog box to change to change this

Tx

Randall
 
Hi
you can't create a 'blank' cell. For your graphing issue you may use
something like
=IF(A1<0,NA(),1)

the #NA error fields should not be graphed in your sheet
 
Back
Top