IF Function... Empty Cell

  • Thread starter Thread starter Wayne
  • Start date Start date
W

Wayne

I Have an IF function to a series of cells that reqire an
empty cell to be inserted if the logical test is false.

IE

=IF(Logic_Test,Value_If_True,Empty_Cell_If_False)


So how do you set an if statement to insert an empty cell?

using "" returns a value to the cell when COUNTA is used
to lookup the cell and hence will not work.


The cell needs to be empty as the cells are linked to a
Dynamic Chart using a COUNTA Function
 
Formulas return values always - if there's a formula in the cell,
COUNTA will count it.

You could use =SUMPRODUCT(--(rng<>"")) instead
 
You might be able to use =countblank(rng), too.

But it behaves differently than J.E.'s when the range includes cells outside the
usedrange. (Countblank counts them. J.E.'s will ignore them.)
 
Back
Top