By only using Excel functions (no scratch work or pivot tables), create new columns of data to indicate customers who meet the following criteria:

1. Customers whose checking account has more than $10,000
2. Customers who local branch is Mesa and own their own houses with no mortgage
3. Customers with either more than $12,000 in their checking or more than $16,000 in their savings

Please let me know what formulas used, in which cells they are placed in and any other potent information using only excel

DATA

Local Branch	Checking Total	Savings Total	Membership full years	Housing Type	Cust. savings less than $1,000? (1 = Yes, 0 = No)
Phoenix	$ 14,532.02	$ 3,730.26	5	Rent	0
Mesa	$ 5,872.79	$ 4,441.84	2	Other	0
Flagstaff	$ 10,745.51	$ 35,711.40	6	Other	0
Flagstaff	$ 1,374.56	$ 8,227.38	4	Other	0
Flagstaff	$ 339.99	$ 61.03	21	Own (Mortgage)	1
Tucson	$ 1,279.72	$ 16,734.61	3	Own (No Mortgage)	0
Tucson	$ 4,293.68	$ 3,653.68	2	Other	0
Flagstaff	$ 5,366.53	$ 29,107.18	0	Other	0
Tucson	$ 1,912.55	$ 2,148.95	1	Own (Mortgage)	0
Phoenix	$ 4,332.41	$ 1,561.38	6	Rent	0
Flagstaff	$ 18,638.92	$ 321.97	5	Other	1
Mesa	$ 15,764.68	$ 6,518.29	4	Rent	0
Mesa	$ 10,963.35	$ 552.45	1	Own (Mortgage)	1
Mesa	$ 6,051.82	$ 4,810.80	3	Own (No Mortgage)	0
Mesa	$ 8,197.35	$ 6,326.65	0	Own (No Mortgage)	0
Tucson	$ 13,938.41	$ 2,497.00	14	Other	0
Phoenix	$ 2,214.99	$ 3,083.23	2	Rent	0
Tempe	$ 1,210.75	$ 25,779.19	2	Rent	0
Flagstaff	$ 8,756.57	$ 290.42	2	Own (No Mortgage)	1
Phoenix	$ 4,031.87	$ 1,289.22	15	Own (Mortgage)	0
Tempe	$ 321.44	$ 1,990.10	9	Own (Mortgage)	0
Mesa	$ 6,248.68	$ 241.92	1	Other	1
Phoenix	$ 5,728.17	$ 18,797.67	1	Rent	0
Tempe	$ 6,002.61	$ 7,359.45	10	Own (No Mortgage)	0