Writing IF FORMULA

[Creekleo]

Hello community ,

I want to write an IF FORMULA BASED on the criteria in table below :

i want this to be shown in the rang column based on the actual % rang. thank you so much

Between 0% and 20%

21% - 60%

61% - 80%

81% - 100%

> 100%

Classeur2
	A	B	C	D
1	Actual %	RANG
2	0%	IF FORMULA
3	0%
4	0%			Between 0% and 20%
5	0%			21% - 60%
6	0%			61% - 80%
7	0%			81% - 100%
8	24%			> 100%
9	0%
10	0%
11	0%
12	0%
13	0%
14	0%
15	28%
16	0%
17	0%
18	0%
19	0%
20	61%
21	100%
22	8%
23	53%
24	23%
25	148%
26	0%
27	0%
28	39%
29	0%
30	158%
31	8%
32	0%
33	0%
34	0%
35	0%
36	0%
37	20%
38	0%
39	0%
40	70%
41	0%
42	0%
43	0%
44	272%
45	331%
46	241%
47	0%
48	0%
49	0%
50	0%
51	208%
52	127%
53	131%
54	344%
55	0%
56	62%
57	20%
58	266%
59	0%
60	0%
61	0%
62	0%
63	0%
64	290%
65	0%
66	0%
67	200%
68	85%
69	32%
70	12%
71	0%
72	0%
73	0%
74	0%
75	59%
76	0%
77	555%
78	45%
79	51%
80	120%
81	1199%
82	0%
83	120%
84	0%
85	60%
86	130%
87	250%
88	81%
89	0%
90	199%
91	158%
92	0%
93	0%
94	42%
95	132%
96	16%
97	217%
98	0%
99	0%
100	121%
101	248%
102	172%
103	23%
104	0%
105	60%
106	0%
107	0%
108	0%
109	30%
110	0%
111	0%
112	0%
113	0%
114	0%
115	75%
116	0%
117	0%
118	0%
119	99%
120	86%
121	0%
122	0%
123	0%
124	0%
125	70%
126	10%
127	131%
128	0%
129	0%
130	50%
131	341%
132	46%
133	181%
134	40%
135	165%
136	150%
137	0%
138	235%
139	60%
140	33%
141	29%
142	0%
143	320%
144	0%
145	69%
146	273%
147	0%
148	30%
149	0%
150	0%
151	0%
152	147%
153	32%
154	353%
155	146%
156	46%
157	189%
158	39%
159	0%
160	57%
161	264%
162	61%
163	29%
164	99%
165	0%
166	0%
167	0%
168	0%
169	0%
170	0%
171	0%
172	0%
173	0%
174	79%
175	0%
176	0%
177	160%
178	0%
179	0%
180	0%
181	0%
182	0%
183	0%
184	0%
185	204%
186	48%
187	43%
188	0%
189	0%
190	0%
191	63%
192	0%
193	0%
194	0%
195	0%
196	223%
197	40%
198	80%
199	0%
200	0%
201	50%
202	0%
203	0%
204	0%
205	0%
206	82%
207	0%
208	0%
209	0%
210	0%
211	30%
212	836%
213	0%
214	0%
215	0%
216	0%
217	0%
218	0%
219	0%
220	0%
221	0%
222	0%
223	299%
224	0%
225	0%
226	119%
227	0%
228	39%
229	50%
230	0%
231	0%
232	40%
233	0%
234	0%
235	0%
236	319%
237	239%
238	0%
239	0%
240	0%
241	0%
242	0%
243	40%
244	0%
245	0%
246	59%
247	0%
248	45%
249	0%
250	408%
251	0%
252	0%
253	0%
254	0%
255	0%
256	0%
257	12%
258	436%
259	20%
260	0%
261	40%
262	112%
263	0%
264	0%
265	60%
266	0%
267	0%
268	0%
269	0%
270	47%
271	100%
272	140%
273	41%
274	60%
275	0%
276	24%
277	227%
278	0%
279	0%
280	0%
281	0%
282	60%
283	0%
284	306%
285	0%
286	65%
287	239%
288	0%
289	0%
290	0%
291	0%
292	0%
293	160%
294	0%
295	196%
296	0%
297	280%
298	60%
299	0%
300	0%
301	0%
302	0%
303	0%
304	0%
305	0%
306	0%
307	0%
308	0%
309	0%
310	160%
311	0%
312	0%
313	0%
314	0%
315	0%
316	0%
317	0%
318	0%
319	0%
320	0%
321	0%
322	0%
323	373%
324	0%
325	0%
326	0%
327	0%
328	80%
329	183%
330	0%
331	0%
332	0%
333	0%
334	0%
335	0%
336	0%
337	0%
338	360%
339	0%
340	21%
341	0%
342	0%
343	0%
344	0%
345	0%
346	0%
347	0%
348	0%
349	0%
350	0%
351	361%
352	28%
353	93%
Feuil1

 

[Joe4]

One way (put formula in B2 and copy down):

=IF(A2>100%,"> 100%",IF(A2>=81%,"81% - 100%",IF(A2>=61%,"61% - 80%",IF(A2>=21%,"21%-60%",IF(A2>=0%,"Between 0% and 20%","")))))

 

[Creekleo]

Thank you Joe, worked perfectly. thanks a lot

 

[Joe4]

You are welcome.