I want to be able to pick the lowest priced item out of these 4 and
display it in a cell. How do I set-up multiple filetering using the IF
fucntion.


A B C D E
1 2 3 4 1

I want the cell to automatically display the lowest number in the
field.

I know =IF(12,2,1) as an expample but I need to know how to use the
AND fucntion in an IF fucntion.

Also, I need to match the title above listed as ABCD to a result name.

Again,

I know =IF(E=A,A,B) to choose between two items but I don't know how to
do it with more than two.

Please Help.

Thanks


--
jfb130
------------------------------------------------------------------------
jfb130's Profile: http://www.excelforum.com/member.php...o&userid=28170
View this thread: http://www.excelforum.com/showthread...hreadid=476982