If Formula

[aarti_rto]

Hello,

please help me with the formula for "ABC" column to get these answers with reference to column "Quantity %" & "% with Issue Value"

when "Quantity %" & "% with Issue Value" both are greater than 1.5% - A
when "Quantity %" & "% with Issue Value" any one is greater than 1.5% - A

when "Quantity %" & "% with Issue Value" both are less than 1.5% - B

when "Quantity %" & "% with Issue Value" both are less than 0.5% - C

Material	Opening Stock	Total Receipt Qties	Total Issue Quantities	Quantity %	% with Issue Value	ABC
1​	65,043​	3,100,957​	-3,163,202​	2.75%​	11.37%​	A
2​	11,185.218​	233,165.900​	-221,586.590​	0.19%​	8.49%​	A
3​	155,747​	4,355,517​	-4,504,726​	3.92%​	8.08%​	A
4​	32,439​	2,876,258​	-2,662,470​	2.32%​	7.54%​	A
5​	285​	1,186,650​	-1,086,585​	0.95%​	5.71%​	A
6​	71,500​	570,891​	-637,797​	0.55%​	5.62%​	A
7​	34,836​	369,367​	-393,527​	0.34%​	4.03%​	A
8​	13,279​	4,090,584​	-4,103,863​	3.57%​	3.80%​	A
9​	3,839​	305,380​	-308,869​	0.27%​	3.55%​	A
10​	3,875​	4,102,104​	-4,104,379​	3.57%​	3.53%​	A
11​	248,791​	1,159,200​	-1,374,771​	1.20%​	3.31%​	A
12​	22,288​	272,466​	-289,631​	0.25%​	2.95%​	A
13​	2,276​	207,907​	-197,842​	0.17%​	2.08%​	A
14​	701,322​	244,768​	-823,490​	0.72%​	1.85%​	A
15​	7,475.096​	18,574​	-25,635.958​	0.02%​	1.79%​	A
16​	200​	360,208​	-340,344​	0.30%​	1.73%​	A
17​	2,449​	129,070​	-130,975​	0.11%​	1.50%​	B
18​	0​	1,539,554​	-1,534,754​	1.34%​	1.39%​	A
19​	610,099​	15,100,000​	-15,321,706​	13.33%​	1.18%​	A
20​	1,488,000​	13,704,586​	-14,900,737​	12.96%​	1.11%​	A
21​	173,658​	705,756​	-875,100​	0.76%​	1.05%​	B
22​	16,800​	61,175​	-75,936​	0.07%​	0.89%​	B
23​	774,915​	667,006​	-1,262,194​	1.10%​	0.88%​	A
24​	791​	154,632​	-152,877​	0.13%​	0.85%​	B
25​	765,100​	519,482​	-1,174,805​	1.02%​	0.82%​	A
26​	318,409​	15,592,579​	-15,138,179​	13.17%​	0.81%​	A
27​	1,914,650​	14,580,482​	-14,827,298​	12.90%​	0.73%​	A
28​	8,085​	80,123​	-84,284​	0.04%​	0.27%​	C
29​	3,001​	95,268​	-97,267​	0.05%​	0.23%​	C
30​	2,597​	32,561​	-34,941​	0.02%​	0.23%​	C

 

[Joe4]

I think your question is missing some important detail.
Can you tell us the criteria, for when it should return "A" versus "B" versus "C"?

 

[aarti_rto]

ok,,added

 

[Joe4]

Try this formula (assuming the two columns you are checking are E and F, the following would be the formula for row 2):

=IF(AND(E2<0.5%,F2<0.5%),"C",IF(AND(E2<1.5%,F2<1.5%),"B","A"))