Home/ Questions/Q 177
Next
computing
  • 23
Asked: 2021-09-03T01:59:52+00:00 In:

Creating blank cells in excel

  • 23

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