Excel formula help

For the geeks I need a formula to find out the following

- time less than 0, ccnoob claim timeout
- time 0 to 24, ccnoob move
- time greater than 24, ccnoob chill

I can get it working for two conditions, but with the 3 i need a nested if statement. Anyone come up with a solution?

Originally posted by CCNoob
For the geeks I need a formula to find out the following

- time less than 0, ccnoob claim timeout
- time 0 to 24, ccnoob move
- time greater than 24, ccnoob chill

I can get it working for two conditions, but with the 3 i need a nested if statement. Anyone come up with a solution?

Originally posted by FabianFnas
Then why not use a nested condition?

Originally posted by CCNoob
I was hoping you would provide it.

=IF(I10<24,"Move",IF(I10>24,Chill,IF(I10<0,"timeout","chill"😉))

This attempt returns, move for -3 when it should return timeout.

Originally posted by mikelom
Nothing in RHP comes for free! 😉

Not even a picture or event history! 😏

=IF(I10<0, "timeout", IF(I10>24, "chill", "move" ))

Originally posted by PBE6
=IF(I10<0, "timeout", IF(I10>24, "chill", "move" ))