conditional formula
 

Hi

I am looking for a conditional formula:

The YTD sheet is referencing data from the Quarter sheet, the Quarter
sheet is referencing data from the Monthly, if any sheet's value is 0 I do
not want that sheet referenced in the results, Is there a formula for this?

conditional formula
 

Nel ,
Anthony ha scritto:
Hi

I am looking for a conditional formula:

The YTD sheet is referencing data from the Quarter sheet, the
Quarter sheet is referencing data from the Monthly, if any sheet's
value is 0 I do not want that sheet referenced in the results, Is
there a formula for this?

Hi Anthony,

try something like this:

=IF(your_formula,your_formula,"")


--
(I'm not sure of names of menus, options and commands, because
translating from the Italian version of Excel...)

Hope I helped you.


Thanks in advance for your feedback.


Ciao


Franz Verga from Italy