I have a workbook in which on worksheet 1, cell A40 has the formula:
=average(B8:B38)

Then, on worksheet 2, I would like the cell A1 to have:
= worksheet 1'!B40

EXCEPT, if the result equals zero, then I would like the result to say
"NODI=C".

What syntax do I use to formulate this IF STATEMENT?

In plain words, I want it to be:
= worksheet 1!B40, enter the result, if the result is zero, then display
"NODI=C"
--
Melody