Formulae Help

[JEM]

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.

 

[Robert Flanagan]

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]

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?

 

[FloMM2]

JEM,
The logical test is "If(' Data'!$O$32=0" without the " ",value_if_true is"
"" " without the first and last quotes, value_if_true is, " ' Data'!$O$32"
without the first and last quotes.
In english the statement says, if the value on sheet ' Data' in cell O32 is
equal to zero, then display nothing, else display the value on sheet ' Data'
in cell O32.
hope this answered your question.

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?

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







.