Multiple "If" Functions In One Cell

Hello folks. I am looking to add two-three "IF" functions into one cell. My current formula is =IF(C9<8.1,1,2) I am attempting to enter a value of 1 if less than 8.1 a value of 2 if less than 16.1 and a value of 3 if less than 24.1

Any help would be appreciated

Try this:

=IF(C9<8.1,1,IF(C9<16.1,2,IF(C9<24.1,3,4)))

Phuocam, Thank You! This formula worked! You are a life saver :-) well time saver at least. Again thank you!

Here is another one to try;

=IFS(C9<8.1,1,C9<16.1,2,C9<24.1,3)

=INT((c9-0.1)/8)+1