Logical Test, 3 Values

Okay so I know the basic equation for a logic test (=IF(A6>A5,"Choice A","Choice B") but I need to compare 3 values. For example, three fields need to be compared (A5, A6, A7) and the lesser of the three needs to be chosen.

In know this is basic, I'm a noob.

Thanks.

How about the MIN() function..

e.g

=MIN(A5:A7)

or

=CHOOSE(MATCH(MIN(A5:A7),A5:A7,0),"X","Y","Z")

if you want to x,y, or z based on which is the minimum.

or

=INDEX({"X","Y","Z"},MATCH(MIN(A1:C1),A1:C1,0))