excel 2003 help comparing prices for lowest
 

I am trying to compare prices from various customers to find who have the
lowest prices.


Company A Company B Company C
Company D


B4 E4 H4
K4 Result
$3.00 $4.00 $2.00 $10.00 company B



I wrote this formula and go this result

=IF(B4K4,IF(B4H4,IF(B4E4,IF(K4B4,IF(K4E4,E4,K 4),H1),B1)),E1)

but it is not giving me the correct answer always, I know i am missing
something but not sure where to add the correct formula. Also if the cell is
blank I want to just disregard the cell. If 2 or more customers have the
same price I want to display that information. I think this is
"concatenate".
any help would be appreciated

excel 2003 help comparing prices for lowest
 

Use MIN instead: MIN(range_with_values)
In order to know the number of companies with that price, use COUNTIF, to
find the value from the MIN formula in the range with the prices.
--
It is nice to be important, but it is more important to be nice


"paul" wrote:

I am trying to compare prices from various customers to find who have the
lowest prices.


Company A Company B Company C
Company D


B4 E4 H4
K4 Result
$3.00 $4.00 $2.00 $10.00 company B



I wrote this formula and go this result

=IF(B4K4,IF(B4H4,IF(B4E4,IF(K4B4,IF(K4E4,E4,K 4),H1),B1)),E1)

but it is not giving me the correct answer always, I know i am missing
something but not sure where to add the correct formula. Also if the cell is
blank I want to just disregard the cell. If 2 or more customers have the
same price I want to display that information. I think this is
"concatenate".
any help would be appreciated

excel 2003 help comparing prices for lowest
 

Thank you Miguel
MIN worked I have to work on the countif now.


"Miguel Zapico" wrote in message
...
Use MIN instead: MIN(range_with_values)
In order to know the number of companies with that price, use COUNTIF, to
find the value from the MIN formula in the range with the prices.
--
It is nice to be important, but it is more important to be nice


"paul" wrote:

I am trying to compare prices from various customers to find who have the
lowest prices.


Company A Company B Company C
Company D


B4 E4
H4
K4 Result
$3.00 $4.00 $2.00 $10.00 company B



I wrote this formula and go this result

=IF(B4K4,IF(B4H4,IF(B4E4,IF(K4B4,IF(K4E4,E4,K 4),H1),B1)),E1)

but it is not giving me the correct answer always, I know i am missing
something but not sure where to add the correct formula. Also if the cell
is
blank I want to just disregard the cell. If 2 or more customers have the
same price I want to display that information. I think this is
"concatenate".
any help would be appreciated

excel 2003 help comparing prices for lowest
 

Maybe an example could help. If your data is in A3:D3, and you put the
formula "=MIN(A3:D3)" in the cell A5, then the formula for the countif should
be "=COUNTIF(A3:D3,A5)"

--
It is nice to be important, but it is more important to be nice


"paul" wrote:

Thank you Miguel
MIN worked I have to work on the countif now.


"Miguel Zapico" wrote in message
...
Use MIN instead: MIN(range_with_values)
In order to know the number of companies with that price, use COUNTIF, to
find the value from the MIN formula in the range with the prices.
--
It is nice to be important, but it is more important to be nice


"paul" wrote:

I am trying to compare prices from various customers to find who have the
lowest prices.


Company A Company B Company C
Company D


B4 E4
H4
K4 Result
$3.00 $4.00 $2.00 $10.00 company B



I wrote this formula and go this result

=IF(B4K4,IF(B4H4,IF(B4E4,IF(K4B4,IF(K4E4,E4,K 4),H1),B1)),E1)

but it is not giving me the correct answer always, I know i am missing
something but not sure where to add the correct formula. Also if the cell
is
blank I want to just disregard the cell. If 2 or more customers have the
same price I want to display that information. I think this is
"concatenate".
any help would be appreciated

excel 2003 help comparing prices for lowest
 

See my post in for an approach that takes ties into account:

http://www.mrexcel.com/board2/viewtopic.php?t=72823


paul wrote:
I am trying to compare prices from various customers to find who have the
lowest prices.


Company A Company B Company C
Company D


B4 E4 H4
K4 Result
$3.00 $4.00 $2.00 $10.00 company B



I wrote this formula and go this result

=IF(B4K4,IF(B4H4,IF(B4E4,IF(K4B4,IF(K4E4,E4,K 4),H1),B1)),E1)

but it is not giving me the correct answer always, I know i am missing
something but not sure where to add the correct formula. Also if the cell is
blank I want to just disregard the cell. If 2 or more customers have the
same price I want to display that information. I think this is
"concatenate".
any help would be appreciated