Test if a value is equal to one of the 3 smallest values of a range of values

Hi all,

• =Small(array;1) works
• =i5={1,2,3,4} works

But

=i5={SMALL(array;1), SMALL(array;2), SMALL(array;3)} doesn't work, excel says it's an inconsistent formula.

What am I doing wrong ?

Thank you for your help !

use like this

=AND(D2=SMALL(A1:A7,1),D2=SMALL(B1:B7,1))

Oo

AND returns true if all tests are true, which of course is not possible.

Again, I have an array, and I would like to test each value of that array and check if it is one of the 3 smallest values of that array. The final goes is to use conditional formatting.

try using or instead of and.
the result will be a Boolean though...

=OR(D2=SMALL(A1:A7,1),D2=SMALL(B1:B7,1))