help with IF statement

[kevinu]

Hi, Im trying to look at a row of numbers on a different sheet (b3;ae3)and if any of them are above 2 (or some other value i choose), then return the value from the first cell (a3). The numbers are sometimes in negative and positive.

I tried:

=IF(ABS('Max - Bins'!B3:AE3)>=1,'Max - Bins'!A3)

I get a FALSE replay but it should be a true reply because there are numbers above 1. It does work when I make it >=.3 or less, which is weird and makes me think im messing up the ABS part of this because most of the numbers in the row are negative.

Here are some of the values I'm looking at in be:ae3

-0.229 -0.210 -0.466 -0.598 -0.778 -0.946 -0.994 -1.058 -0.972 -0.793 -0.749 0.619 -0.311

[Phuocam]

Try this ...

=IF(OR(ABS('Max - Bins'!B3:AE3)>=1),'Max - Bins'!A3)

Enter with C+S+E, or:

=IF(OR(MAX('Max - Bins'!B3:AE3)>=1,MIN('Max - Bins'!B3:AE3)<=-1),'Max - Bins'!A3)

Normal enter.

[kevinu]

The array worked great. If you can explain to me why did it need the or statement to work?