computing
  • 0

Creating blank cells in excel

  • 0

Hello,

Does anyone know how to make Excel treat a cell as blank if there is a formula in it?

I have a formula which puts the contents of one cell into another
=IF((Y4>5),””,X4)

In some cases the reference cell is blank so no value is entered into the cell.

However, when I plot a chart of this data, the empty cells are plotted as zero.

Is there a way to have the empty cells *not* plotted? As I would rather have gaps in the graph, or interpolate between missing values.

I know that if you go to tools>options>chart you can select how to represent blank cells in a chart. My problem is creating the blank cell in the first place.

Any help would be totally appreciated.

Thanks!

ps

Share

0 Answers

  1. Turns out its:
    =IF((Y4>5),NA(),L4)

    I thought I better put the answer up in case someone else had the same problem.

    Thanks anyway!:)

    • 0