Hi all

I am a newbie to the site so thanks for any help in advance.

I really could do with some advice on a problem I have.

I understand the IF command but the criteria always seems to be to use a CELL and then have a result presented when it is more or less than a fixed value. What I am trying to do is get a response from another cell i.e. a comparison between two numbers. I have the below command in and it works.

=IF(O6<Q6,"YES","NO")

However if I change the result in cell O6 to be more than Q6 it still remains as a YES and never returns a NO response.

Any ideas ?