Help with IF function

J

jfb130

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(1>2,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
 
T

tobriant

Can you just use the Min function?



---------------------------------
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(1>2,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
 
J

jfb130

Thanks for your help. The min fuction definately worked for my first
problem. Now how to get the name to display the matching value.
 
P

paul

if your little table is A1 to d2 in e2 you have your min formula in e1 have
=INDEX(A1:D1,,MATCH(E2,A2:D2,0))
 
Top