Hi,

I have made a forumla using the index formula.

If the cell is blank how do i make it come out on the line graph as blank rather than putting it as 0.

I know its the IF formula, but i dont know how to add it to the formula.


An example of the formula is:=INDEX('Overall Data Sheet'!PF206:PF256,$ZW$1)

If the cell = 0 i just want it to connect to the next cell on the line graph rather than class itself as 0.