Return contents of A1 in field S1 if B1 is smallest value in array

[ac0515]

I would be most appreciative if someone could help with the following. This seems pretty simple, but I can't figure it out.

I'd like to move the value contained in A1 to S1 if the value in B1 has the smallest value in an array B1,B10,B20,B30,B40,B50. If it isn't the smallest, then return 0 to S1.

Thanks!!

[shg]

In S1, =(B1=MIN(B1,B10,B20,B30,B40,B50))*A1

[ac0515]

Thank you!

[shg]

You're welcome.