How to ignore black cells

[ACrossley1]

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.

[etaf]

=IF ( INDEX('Overall Data Sheet'!PF206:PF256,$ZW$1) = 0, "" , INDEX('Overall Data Sheet'!PF206:PF256,$ZW$1) )

But for a graph you probably want #N/A so that it ignores that entry - rather than a blank which will still graph

=IF ( INDEX('Overall Data Sheet'!PF206:PF256,$ZW$1) = 0, #N/A , INDEX('Overall Data Sheet'!PF206:PF256,$ZW$1) )

[micope21]

Hi

Use =if($A1="","",INDEX('Overall Data Sheet'!PF206:PF256,$ZW$1)
or
=IFERROR(INDEX('Overall Data Sheet'!PF206:PF256,$ZW$1),"")
or
=IF ( INDEX('Overall Data Sheet'!PF206:PF256,$ZW$1) = 0, "" , INDEX('Overall Data Sheet'!PF206:PF256,$ZW$1) )

Regard