Help with IFS function

Hi All,

I am looking for some help. I am looking to use the IFS function to give a number (rating) depending on the number in question. For example to follow the table below.

If number is less than 5
Then score it 1

If number is between 6-10
Then score it 2

If number is between 11-26
The score it 3

If number is greater than 27+
Then score it 4

I am using the below which seems to work on scoring something 1 or 4 but not 2 and 3. Any help would be appreciated.

=IFS(C5<5,1,C5>5<=10,2,C5>10<=26,3,C5>27,4)

Thank you, this worked perfectly.

Sorry to ask something else but do you know if it is possible to count number from two columns and add them together? Example below.

In one cell I would like to be able to know the following:

If number in C4 is less than 5 in C4 then score it 1
If number in C4 is between 6-10 then score it 2
If number in C4 is between 11-26 then score it 3
If number in C4 is greater than 27+ then score it 4
If number in C5 is less than 4 then score it 1
If number in C5 is between 5-10 then score it 2
If number in C5 is between 11-23 then score it 3
If number in C5 is greater than 24+ then score it 4

Then combine the two numbers for a total.

I hope this makes sense : )