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