Small IF(AND) formula returning false

[astole]

=IF(AND($C$2="Snowball Set No Excess (By Lowest Balance) ",S32=SMALL($R32:$AC32,COUNTIF($R32:$AC32,0)+1)),$AO30)

R32 through AC32 have values. Intent is that if S32 is the smallest out of all of them, then it will equal to AO30 which has value of 70.

It works on my other formula but this one is returning false when AO30 actually has a value.

[NeedForExcel]

I think that is because you have Set only the True condition of the If, not the False condition. If the answer is false, the formula will return "False", if not specified else wise..

[astole]

What would the formula be then?

[NeedForExcel]

Is is possible to attach a Sample Workbook?

[:) Sixthsense :)]

If ALL the conditions which you mentioned in the AND function is getting matched means you will get the AO30 cell value as result else the formula will result you FALSE as result.