Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Compare and get the best value
I use Excel 2003. I am doing a detailed analysis to make a "make or buy"
decision. I have a table containing columns QUANTITIES - BUYING COST - MAKING COST. Data run into sevaral rows according to buying quantites and related costs. I need to find out the "QUANTIES WHERE BUYING COST IS LOWER THAN MAKING COST" to help my boss to decide at what quanties it is economical to start buying. I tried VLOOKUP / HLOOKUP /IF etc. nothing worked. I will be grateful if any body help me to solve this problem? Satya Nanduri |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Compare and get the best value
If you put this formula in D2:
=IF(B2<C2,"Yes","No") and copy down, then you can apply autofilter to column D and select "Yes" from the filter pull-down. Hope this helps. Pete On Jul 11, 6:54*pm, Satya Nanduri wrote: I use Excel 2003. *I am doing a detailed analysis to make a "make or buy" decision. *I have a table containing columns QUANTITIES - BUYING COST - MAKING COST. *Data run into sevaral rows according to buying quantites and related costs. *I need to find out the "QUANTIES WHERE BUYING COST IS LOWER THAN MAKING COST" to help my boss to decide at what quanties it is economical to start buying. * I tried VLOOKUP / HLOOKUP /IF etc. *nothing worked. *I will be grateful if any body help me to solve this problem? * Satya Nanduri |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Compare and get the best value
Thanks for this. This is an idea, but doesn't answer my question. I am
looking for a formula in one cell that changes dynamically when the source data changes. Satya Nanduri "Pete_UK" wrote: If you put this formula in D2: =IF(B2<C2,"Yes","No") and copy down, then you can apply autofilter to column D and select "Yes" from the filter pull-down. Hope this helps. Pete On Jul 11, 6:54 pm, Satya Nanduri wrote: I use Excel 2003. I am doing a detailed analysis to make a "make or buy" decision. I have a table containing columns QUANTITIES - BUYING COST - MAKING COST. Data run into sevaral rows according to buying quantites and related costs. I need to find out the "QUANTIES WHERE BUYING COST IS LOWER THAN MAKING COST" to help my boss to decide at what quanties it is economical to start buying. I tried VLOOKUP / HLOOKUP /IF etc. nothing worked. I will be grateful if any body help me to solve this problem? Satya Nanduri |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Compare | Excel Worksheet Functions | |||
need help with compare macro | Excel Discussion (Misc queries) | |||
Compare | Excel Worksheet Functions | |||
How do I compare cells and if FALSE compare to next cell in EXCEL | Excel Worksheet Functions | |||
compare | Excel Worksheet Functions |