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

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

Melody wrote:

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

--

Dave Peterson

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

"Melody" wrote in message
...
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

Try this:

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

HTH,

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


"Melody" wrote in message
...
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