Solved: Picking out data

[Tenspeed39355]

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

[malik641]

Morning!
This seemed to work:

=IF(OR(A4:P4>J4),"Over","Under")

Enter this as an array formula by pressing Ctrl+Shift+Enter

HTH

[Tenspeed39355]

HTH Thanks your guys are great. I will give you a top rating
Max

[malik641]

Sweeeeet!

[Tenspeed39355]

At first I could not get the formula to work until I read the part Ctrl,Shift,Enter. LOL