need help with syntax of if statement

  • Thread starter Thread starter Melody
  • Start date Start date
M

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"
 
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"
 
Back
Top