If statement between ranges

[Sushiboy]

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

 

[Fluff]

How about

IF(S2<=90,"0-3 Months",IF(S2<=180,"3-6 Months",IF(S2<=360,"6-10 Months","12 Months")))

 

[Sushiboy]

How about

IF(S2<=90,"0-3 Months",IF(S2<=180,"3-6 Months",IF(S2<=360,"6-10 Months","12 Months")))

Thanks Fluff...worked perfectly

 

[Fluff]

You're welcome & thanks for the feedback.