if function - evaluating 2 cells - help

  • Thread starter Thread starter Terry
  • Start date Start date
T

Terry

Hello,

I am trying to do this:
=IF(A5=B5,OK,NOTOK)

It does not seem to like that I am evaluating 2 cells. This works:
=IF(A5=100,OK,NOTOK)

How do I do what I want here?

Thanks!
 
Hi
are your sure both cellsare really indetical. what is in these cells

--
Regards
Frank Kabel
Frankfurt, Germany

Terry said:
Hello,

I am trying to do this:
=IF(A5=B5,OK,NOTOK)

It does not seem to like that I am evaluating 2 cells. This works:
=IF(A5=100,OK,NOTOK)

How do I do what I want here?

Thanks!

----== Posted via Newsfeeds.Com - Unlimited-Uncensored-Secure Usenet News==----
http://www.newsfeeds.com The #1 Newsgroup Service in the World! 120,000+ Newsgroups
----= East and West-Coast Server Farms - Total Privacy via Encryption
Click to expand...
=----
 
No, that's why I am evaluating them. I forgot to say that it is
returning #NAME?

These cells contain numbers. I want to know if they are the same or
not. and if not, place some text in a different cell....
 
Hi
=IF(A5=B5,"OK","NOTOK")

--
Regards
Frank Kabel
Frankfurt, Germany

Terry said:
Hello,

I am trying to do this:
=IF(A5=B5,OK,NOTOK)

It does not seem to like that I am evaluating 2 cells. This works:
=IF(A5=100,OK,NOTOK)

How do I do what I want here?

Thanks!

----== Posted via Newsfeeds.Com - Unlimited-Uncensored-Secure Usenet News==----
http://www.newsfeeds.com The #1 Newsgroup Service in the World! 120,000+ Newsgroups
----= East and West-Coast Server Farms - Total Privacy via Encryption
Click to expand...
=----
 
=IF(A3=B3,"OK","NOTOK") you need the quotation marks.

I cut and pasted your formula into Excel 2002 SP3 with the same results
#NAME.
I entered the formula with the function wizard and it added the quotes. It
worked for me.
 
Back
Top