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]

You did not explain " does not work"? In what way?
Be aware that a number between double quotes is text
Can O3 be smaller than 22 or larger than 31 ?
Perhaps

=If(and(O3>21,O3<30),O3-21,03-22))

 

[omsumo]

Many thanks,
O3 (cell reference)
22 (cell value)
"1" (result)

 

[arthurbr]

Many thanks,
O3 (cell reference)
22 (cell value)
"1" (result)

Do you mean your problem is solved?

 

[Peter_SSs]

I suggest that you update your Account details (or click your user name at the top right of the forum) so helpers always know what Excel version(s) & platform(s) you are using as the best solution often varies by version. (Don’t forget to scroll down & ‘Save’)

Giving us a formula that does not work does not help much. What would help is giving us some sample data and telling/showing us what is the expected result and why.
This might help greatly: XL2BB

 

[omsumo]

No my dear
i need a formula to solve it

 

[Peter_SSs]

No

Then please review my post above.

 

[omsumo]

Then please review my post above.

I did

 

[Peter_SSs]

I did

That post asked for ..

.. giving us some sample data and telling/showing us what is the expected result and why.
This might help greatly: XL2BB

So could you give us that?

Thanks for updating your version details though.

 

[omsumo]

here you are