Help with IF function

  • Thread starter Thread starter jfb130
  • Start date Start date
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
 
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
 
Thanks for your help. The min fuction definately worked for my first
problem. Now how to get the name to display the matching value.
 
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))
 
Back
Top