Lookup Help

[Warn]

Helped her with one vlookup problem but these last two stumped me.

Add a column that shows if a ZIP code has a high population of children and a low number of competitors. High child population is anything greater than or equal to 30% of children population over total population. Low competitors is if a ZIP code has less than or equal to two competitors.

Add a column that shows what ZIP codes would qualify as being potential locations for a new store. A potential location is any ZIP code that has high children and low competition, or an average household income greater than $50,000. However, a ZIP code cannot be considered for a new store if it has more than five competitors.

Any help would be appreciated.....

Excel Workbook
	A	B	C	D	E	F	G
2	Zip Code	City	ST	Population	Child Population Age 0-14	Avg Household Income	Number of Competitors
3	02138	Cambridge	MA	199876	88225	$ 62,096.33	4
4	02777	Swansea	MA	383570	70560	$ 47,030.32	7
5	06385	Waterford	CT	222261	56806	$ 52,744.96	3
Potential Locations

Excel 2010

 

[Warn]

Anyone?
I keep getting an error.

 

[Dryver14]

Try This in H3

=IF(G3>5,"No",IF(F3<50000,"No",IF((E3/D3)*100>29,"Yes","No")))

 

[Marcelo Branco]

Hi,

If i understood correctly you want two new columns

First

Add a column that shows if a ZIP code has a high population of children and a low number of competitors. High child population is anything greater than or equal to 30% of children population over total population. Low competitors is if a ZIP code has less than or equal to two competitors

Formula
=IF(AND(E3/D3>=0.3,G3<=2),"YES","NO")

Second

Add a column that shows what ZIP codes would qualify as being potential locations for a new store. A potential location is any ZIP code that has high children and low competition, or an average household income greater than $50,000. However, a ZIP code cannot be considered for a new store if it has more than five competitors.

Formula
=IF(OR(AND(E3/D3>=0.3,G3<=2),AND(F3>50000,G3 <= 5)),"YES","NO")

HTH

M.