It is saying, This function not valid!
when I type in the formulae underneath comes up:

If(logical_test,[value_if_true],[value_if_false])

what is the logical_test?


"Robert Flanagan" wrote:

How about:

=If(' Data'!$O$32=0, "",' Data'!$O$32)

Robert Flanagan
http://www.add-ins.com
Productivity add-ins and downloadable books on VB macros for Excel




"JEM" wrote in message
news
Could anyone please tell me, I have developed a worksheet template were I
have sourced the data labels in my chart. Sometimes this means 0 is
inserted
in the chart and I wondered if it was possible when I used the formulae
below
that I could state that if the source cell equalled 0 then this should not
be
used.

=' Data'!$O$32

Many Thanks in anticipation.


.