Excel Help

[mark111]

I’m not very experienced with excel. I want to be able to input a number and in the cell beneath it a different number is displayed based on the value above. If the input value (x) is greater than 5, a 5 is displayed, if x>=3<5, a 4 is displayed, if x>=1<3, a 3 is displayed, if x>=0<1, a 2 is displayed, and if x<0, a 1 is displayed.

[Base10]

Hey,

The link below may help.  Its IF functions in excel.

https://support.microsoft.com/en-us/office/if-function-69aed7c9-4e8a-4755-a9bc-aa8bbff73be2#:~:text=Use%20the%20IF%20function%2C%20one,another%20value%20if%20it's%20false.&text=For%20example%3A,B4%2DA4%2C%22%22)