Tenspeed39355
11-11-2005, 08:00 AM
Good morning guys
The problem I have is In A4:P4 I have some numbers. In another cell J4 I have
a number also. How do I find out if any of the numbers in A4:P4 are over or under the
Number in J4? The answer can be the words "Over" or "Under"
It would be nice if the Cell that that number that was over or under was the answer. I can go with either. Thanks for your help.
I tried the IF command =IF(A4:P4>J4,"Over","Under") That is not working.
Max:hi:
The problem I have is In A4:P4 I have some numbers. In another cell J4 I have
a number also. How do I find out if any of the numbers in A4:P4 are over or under the
Number in J4? The answer can be the words "Over" or "Under"
It would be nice if the Cell that that number that was over or under was the answer. I can go with either. Thanks for your help.
I tried the IF command =IF(A4:P4>J4,"Over","Under") That is not working.
Max:hi: