Help with IF 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(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

Help with IF function
 

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(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


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

Help with IF function
 

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


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

Help with IF function
 

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))
--
paul
remove nospam for email addy!



"jfb130" wrote:


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


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