need help with syntax of if statement

[Melody]

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"

 

[Dave Peterson]

=if('worksheet 1'!b40=0,"NODI=C",'worksheet 1'!b40)

 

[Gaurav]

=IF(worksheet1!B40<>0,worksheet1!B40,"NODI=C")

 

[RagDyeR]

Try this:

=IF('worksheet 1'!B40,'worksheet 1'!B40,"NODI=C")
--

HTH,

RD
=====================================================
Please keep all correspondence within the Group, so all may benefit!
=====================================================


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"