Struggling to get this to work.
Column A has a range of number of days
Trying to place a value so that if the number falls in a range, this will produce the narrative. Any ideas ppl please?
IF(AND(S2>=0,S2<=90,"0-3 Months",S2>=91,S2<=180,"3-6 Months",S2>=181,S2<=360),"6-10 Months","12 Months")
Ageing Business Days
12
12
12
13
13
14
16
17
17
18
21
24
24
24
24
24
24
24
29
29
40
44
44
44
44
44
44
61
66
67
74
76
78
103
131
174
197
208
230
271
289
296
356
362
369
381
389
404
419
431
457
684
904
Column A has a range of number of days
Trying to place a value so that if the number falls in a range, this will produce the narrative. Any ideas ppl please?
IF(AND(S2>=0,S2<=90,"0-3 Months",S2>=91,S2<=180,"3-6 Months",S2>=181,S2<=360),"6-10 Months","12 Months")
Ageing Business Days
12
12
12
13
13
14
16
17
17
18
21
24
24
24
24
24
24
24
29
29
40
44
44
44
44
44
44
61
66
67
74
76
78
103
131
174
197
208
230
271
289
296
356
362
369
381
389
404
419
431
457
684
904