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

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

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