IF Statement question

  • Thread starter Thread starter Doug Mc
  • Start date Start date
D

Doug Mc

What is the matter with this IF statement? It shows zero rather than the
contents of N111

=IF(N1='GRO/INC',N111,0)

Thanks,
Doug
 
Hi Doug:

Try enclosing "GRO/INC" in double quotes.

For some reason that I don't fully understand, when I tried it with single
quotes, I got a circular reference. Very strange.

Regards,

Vasant.
 
Thanks guys,

That made it work ok when true; it returned the correct amount; but.......
When it was false, and should have returned zero, it returned some other
number - I don't know where from...

Any ideas?
Doug
 
Make sure the cell is formated as a number
--

Doug Mc said:
Thanks guys,

That made it work ok when true; it returned the correct amount; but.......
When it was false, and should have returned zero, it returned some other
number - I don't know where from...

Any ideas?
Doug
Click to expand...
 
Hmmm, I guess N1 does not equal "GRO/INC and it's
returning the value of zero. It's doing exactly what it's
written to do.

By the way,if some knows how to make an IF function do
nothing if a logical expresion is false (meaning not
changing the data in the cell)please e-mail me with the
solution.
 
Back
Top