Multiple ifs in a cell

[maddock]

Hi Guys i need some help.
So the value that i have as follows
<10,000 = 30%
more than 10,000 but less than 20,000 = 50%
More than 20,000 but less than 100,000 = 70%
More than 100,000 = 90%

I want to create a formula that recognizes a cell's value and reflects the % as above when the value is as the conditions above

can someone help with the formula i cant find any online.

Hope my question is clear

 

[awoohaw]

try:

mr excel questions 34.xlsm
	A	B	C
1	Value	Calculation
2	5000	0.3
3	9999	0.3
4	10000	0.5
5	10001	0.5
6	19999	0.5
7	20000	0.7
8	20001	0.7
9	99999	0.7
10	100000	0.9
11	100001	0.9
maddock

Cell Formulas
Range	Formula
B2:B11	B2	=IFS(A2<10000,0.3,A2<20000,0.5,A2<100000,0.7,A2>=100000,0.9)

 

[awoohaw]

try:

mr excel questions 34.xlsm
	A	B	C
1	Value	Calculation
2	5000	0.3
3	9999	0.3
4	10000	0.5
5	10001	0.5
6	19999	0.5
7	20000	0.7
8	20001	0.7
9	99999	0.7
10	100000	0.9
11	100001	0.9
maddock

Cell Formulas
Range	Formula
B2:B11	B2	=IFS(A2<10000,0.3,A2<20000,0.5,A2<100000,0.7,A2>=100000,0.9)

i did not format the cells, but you can do that, I think.

 

[DanteAmor]

Hi @maddock . Welcome to the MrExcel forum. Please accept my warmest greetings and sincere hope that all is well.

I show you 2 ways, check which one you like:

Dante Amor
	A	B	C
1	Value	%	%
2	9,000.00	30%	30%
3	11,000.00	50%	50%
4	25,000.00	70%	70%
5	96,000.00	70%	70%
6	115,000.00	90%	90%
Hoja3

Cell Formulas
Range	Formula
B2:B6	B2	=IF(A2<10000,30%,IF(A2<20000,50%,IF(A2<100000,70%,90%)))
C2:C6	C2	=LOOKUP(A2,{0;10000;20000;100000},{0.3;0.5;0.7;0.9})

Maybe in the array you should use comma:

=LOOKUP(A2,{0,10000,20000,100000},{0.3,0.5,0.7,0.9})

--------------
Let me know the result and I'll get back to you as soon as I can.
Sincerely
Dante Amor
--------------