if a formula in excel with multible conditions

[omsumo]

Dear are there any formula to select a specific value based on the specific condition
I tried this formula but it did not work
=IFs(O3=22,"1",IF(O3=23,"2",IF(O3=24,"3",IF(O3=25,"4",IF(O3=26,"5",IF(O3=27,"6",IF(O3=28,"7",IF(O3=29,"8",IF(O3=30,"8",IF(O3=31,"9"))))))))))

 

[arthurbr]

So what's wrong with my suggestion please? I provided a solution in post #2
You also did not answer my question : " What went wrong?"

 

[Scott R]

=( O3 - IF( O3 >= 30, 22, 21 )) & ""

 

[MountainFog]

It looks like this should not be formulated as IF.

This strikes me as more of a Lookup solution. Create a table as below: (Not sure if the 29 & 30 = 8 was a typo or not)

A	B
22	1
23	2
24	3
25	4
26	5
27	6
28	7
29	8
30	8
31	9

=XLOOKUP(O3,A1:A10,B1:B10)

 

[omsumo]

I try to build the formula in a new sheet it's working (figure No. 1) but my original sheet does not work (figure No.2)
1.

2.

 

[Fluff]

How about

Fluff.xlsm
	N	O
1
2	1	22
3	2	23
4	3	24
5	4	25
6	5	26
7	6	27
8	7	28
9	8	29
10	9	30
11	10	31
12	11	32
13	12	33
14	13	34
15	14	35
Sheet6

Cell Formulas
Range	Formula
N2:N15	N2	=IF(AND(O2>20,O2<36),MOD(O2,21),"")

 

[omsumo]

How about

Fluff.xlsm
	N	O
1
2	1	22
3	2	23
4	3	24
5	4	25
6	5	26
7	6	27
8	7	28
9	8	29
10	9	30
11	10	31
12	11	32
13	12	33
14	13	34
15	14	35
Sheet6

Cell Formulas
Range	Formula
N2:N15	N2	=IF(AND(O2>20,O2<36),MOD(O2,21),"")

Thanks for your permit reply .. it does not cover the whole list

 

[Fluff]

In what way? Your formula only caters for values of 22 to 35 which is what I've shown.

 

[omsumo]

It's working .. sounds great .. many thanks

 

[Fluff]

Glad we could help & thanks for the feedback.

 

[arthurbr]

I try to build the formula in a new sheet it's working (figure No. 1) but my original sheet does not work (figure No.2)
1.
View attachment 106847
2.
View attachment 106848

This is NOT the same as your original question =IFs(O3=22,"1",IF(O3=23,"2",IF(O3=24,"3",IF(O3=25,"4",IF(O3=26,"5",IF(O3=27,"6",IF(O3=28,"7",IF(O3=29,"8",IF(O3=30,"8",IF(O3=31,"9")))))))))), where 22 is deduced from O3 instead of 21 ! You made me waste time unnecessarily