PDA

View Full Version : Solved: Picking out data



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:

malik641
11-11-2005, 08:22 AM
Morning!
This seemed to work:

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

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

:thumb HTH :thumb

Tenspeed39355
11-11-2005, 08:36 AM
HTH Thanks your guys are great. I will give you a top rating
Max

malik641
11-11-2005, 09:05 AM
Sweeeeet! :beerchug:

Tenspeed39355
11-11-2005, 09:07 AM
At first I could not get the formula to work until I read the part Ctrl,Shift,Enter. LOL