Converting an excel IF formula to a Powerpivot DAX formula-EXAMPLE

	A	B	C	D
1	LocationID	OperatorShortName	ProposedTotalDepth	Depth
2	856442	ALTA MESA SERVICES	11300	>8000
3	807464	ANKOR E & P HOLDINGS	15100	>8000
4	870519	ANKOR E & P HOLDINGS	15343	>8000
5	859160	ANKOR E & P HOLDINGS	13899	>8000
6	887445	ANKOR E & P HOLDINGS	15130	>8000
7	898670	BLACK WARRIOR METHNE	3000	<8000
8	900329	BLACK WARRIOR METHNE	3000	<8000
9	900327	BLACK WARRIOR METHNE	3000	<8000
10	906497	BLACK WARRIOR METHNE	3000	<8000
11	906468	BLACK WARRIOR METHNE	3000	<8000
12	845103	CARRIZO OIL & GAS	14500	>8000
13	825300	CRAFT OPERATING	10100	>8000
14	826054	CRAFT OPERATING	9800	>8000
15	910843	DCOR LLC	12500	>8000
16	909990	DCOR LLC	12800	>8000
17	860541	ESCAMBIA OPERATING	15550	>8000
18	877509	ESCAMBIA OPERATING	15450	>8000
19	838419	FAIRWAYS EXPLORATION	15000	>8000
20	838418	FAIRWAYS EXPLORATION	15000	>8000
21	904182	FAIRWAYS EXPLORATION	14200	>8000
22	911683	FAIRWAYS EXPLORATION	14000	>8000
23	839335	FLETCHER PETROLEUM	12500	>8000
24	840536	JABSCO OIL OPERATING	5200	<8000
25	836643	JL RESOURCES LLC	12000	>8000
26	866920	JL RESOURCES LLC	11600	>8000
27	901544	JL RESOURCES LLC	11500	>8000
28	845742	LAND & NATURAL RES.	14560	>8000
29	839789	PALMER PETROLEUM	11500	>8000
30	855757	PETRODOME OPERATING	12000	>8000
31	871253	PETRODOME OPERATING	11034	>8000
32	890293	PHILLIPS ENERGY	13700	>8000
33	825752	PRUET PRODUCTION CO	12500	>8000
34	822866	PRUET PRODUCTION CO	12500	>8000
35	826965	PRUET PRODUCTION CO	12900	>8000
36	819609	PRUET PRODUCTION CO	15000	>8000
37	823102	PRUET PRODUCTION CO	13400	>8000
38	839790	PRUET PRODUCTION CO	12900	>8000
39	839791	PRUET PRODUCTION CO	12900	>8000
40	821897	PRUET PRODUCTION CO	12500	>8000
41	858018	PRUET PRODUCTION CO	12500	>8000
42	861904	PRUET PRODUCTION CO	12900	>8000
43	867978	PRUET PRODUCTION CO	12900	>8000
44	866647	PRUET PRODUCTION CO	12750	>8000
45	871845	PRUET PRODUCTION CO	12500	>8000
46	883658	PRUET PRODUCTION CO	12500	>8000
47	893287	PRUET PRODUCTION CO	12500	>8000
48	895951	PRUET PRODUCTION CO	12800	>8000
49	897460	PRUET PRODUCTION CO	12900	>8000
50	890267	PRUET PRODUCTION CO	12500	>8000
51	909105	PRUET PRODUCTION CO	12500	>8000
52	911289	PRUET PRODUCTION CO	12500	>8000
53	912202	PRUET PRODUCTION CO	12900	>8000
54	926790	PRUET PRODUCTION CO	12500	>8000
55	816742	SAGA PETROLEUM/AL	3000	<8000
56	817150	SAGA PETROLEUM/AL	3000	<8000
57	866208	SAGA PETROLEUM/AL	3000	<8000
58	865797	SAGA PETROLEUM/AL	3000	<8000
59	866210	SAGA PETROLEUM/AL	3000	<8000
60	866209	SAGA PETROLEUM/AL	3000	<8000
61	871254	SAGA PETROLEUM/AL	3000	<8000
62	870521	SAGA PETROLEUM/AL	3000	<8000
63	870520	SAGA PETROLEUM/AL	3000	<8000
64	869877	SAGA PETROLEUM/AL	3000	<8000
65	878204	SAGA PETROLEUM/AL	3000	<8000
66	878203	SAGA PETROLEUM/AL	3000	<8000
67	878806	SAGA PETROLEUM/AL	3000	<8000