A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Excel » Charts and Charting
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Formulae Help



 
 
Thread Tools Display Modes
  #1  
Old February 26th, 2010, 01:58 PM posted to microsoft.public.excel.charting
Jem
external usenet poster
 
Posts: 56
Default Formulae Help

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.
  #2  
Old February 26th, 2010, 02:37 PM posted to microsoft.public.excel.charting
Robert Flanagan
external usenet poster
 
Posts: 22
Default Formulae Help

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.



  #3  
Old February 26th, 2010, 04:24 PM posted to microsoft.public.excel.charting
Jem
external usenet poster
 
Posts: 56
Default Formulae Help

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.



.

  #4  
Old March 3rd, 2010, 09:29 AM posted to microsoft.public.excel.charting
FloMM2
external usenet poster
 
Posts: 189
Default Formulae Help

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.
"JEM" wrote:

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.



.

 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 12:33 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.