Nested Formula, I think?

[Gsrgofass]

Hello All,

I have to populate column B with 1 of 5 responses based on column A entries.
Responses are:

• A blank cell in column A; blank cell in column B
• < 0 days; "Past Due"
• 0 to 15 days; "0 to 15"
• 16-30 days; "16 to 30"
• 31-60+ days; "31-60"

Thanks

 

[Gsrgofass]

Hello All,

I have to populate column B with 1 of 5 responses based on column A entries.
Responses are:

• A blank cell in column A; blank cell in column B
• < 0 days; "Past Due"
• 0 to 15 days; "0 to 15"
• 16-30 days; "16 to 30"
• 31-60+ days; "31-60"

View attachment 88485

Thanks

Is it possible to write the column header name 'Category' into the formula? Would this save from having to copy the formula down into each cell?

 

[awoohaw]

Try this:
Im not sure if IFS is a function available in 2016.

mr excel questions 20.xlsm
	A	B	C
1
2	-5	0 to 15
3	8	0 to 15
4	20	16 to 30
5	35	31-60
6	65	31-60
7
Sheet4

Cell Formulas
Range	Formula
B1:B6	B1	=IFS(A1="","",A1<=15,"0 to 15",A1<=30,"16 to 30",A1>30,"31-60")

 

[awoohaw]

IFS is not in 365, so nested IF's it is:

mr excel questions 20.xlsm
	A	B	C
1		XL365	XL2016
2
3	-5	Past Due	Past Due
4	8	0 to 15	0 to 15
5	20	16 to 30	15 to 30
6	35	31-60	31 - 60
7	65	31-60	31 - 60
Sheet4

Cell Formulas
Range	Formula
B2:B7	B2	=IFS(A2="","",A2<0,"Past Due",A2<=15,"0 to 15",A2<=30,"16 to 30",A2>30,"31-60")
C2:C7	C2	=IF(A2="","",IF(A2<0,"Past Due",IF(A2<=15,"0 to 15",IF(A2<=30,"15 to 30",IF(A2>30,"31 - 60")))))