Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Data from Excel 2000 Worksheet with external links is not displayed when opened in Excel 2003 | Links and Linking in Excel | |||
Excel Re-calculation 2000 compared to 2003 | Excel Discussion (Misc queries) | |||
Excel 2003 crashes loading excel files created Excel 2000 | Excel Discussion (Misc queries) | |||
Comparing a value to a list of values does not work in Excel 2003. | Excel Worksheet Functions | |||
sharing/using/saving Excel 2002 files in Excel 2003 | Excel Discussion (Misc queries) |