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. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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 | |
|
|