IF Statement question

[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

 

[Vasant Nanavati]

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.

 

[Michael Tomasura]

Try this

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

double quotes

 

[Doug Mc]

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

 

[Michael Tomasura]

Make sure the cell is formated as a number
--

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

 

[Doug Mc]

It is.
I just GOOFED!
Thanks for your help.
Doug

Make sure the cell is formated as a number

 

[Eric]

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.