excel 2003 help comparing prices for lowest

  • Thread starter Thread starter paul
  • Start date Start date
P

paul

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(B4>K4,IF(B4>H4,IF(B4>E4,IF(K4>B4,IF(K4>E4,E4,K4),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
 
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.
 
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)"
 
Back
Top