Formula required

[vvinod]

Hi,

Kindly develop a formula for below

Category	Provision Bucket	Cat.
Finished Goods	0 % - 10 %	100%
	10 % - 25 %	75%
	25 % - 50 %	30%
	50 % - 75 %	15%
	more than 75%

Below is the data column and above is the condition

Life	Cat.	Prov Required in AED	Provision Bucket	Category
98%	0%	-		Finished Goods

for example if FG life is 98% then Provision bucket should be 0%. We need to take provision bucket, in category there is RM also

 

[DanteAmor]

I recommend dividing the Provision Bucket column into 2 columns: From and To.
Use the following formula:

Dante Amor
	A	B	C	D	E
1	Category	Provision Bucket From	To	Cat.
2	Finished Goods	0	10%	100%
3		10.01%	25%	75%
4		25.01%	50%	30%
5		50.01%	75%	15%
6	more than	75.01%	100%	0%
7
8
9
10
11	Life	Cat.	Prov Required in AED	Provision Bucket	Category
12	98%	0%	-	0%	Finished Goods
13	75%			15%
14	26%			30%
15	24%			75%
16	8%			100%
17	1%			100%
Hoja4

Cell Formulas
Range	Formula
D12:D17	D12	=VLOOKUP(A12,$B$2:$D$6,3,1)