You're pretty close. Instead of writing separate IF statements you
need to nest them so the "false" argument is the beginning of the next
IF. Additionally, you have OR statements when you need AND statements,
and the "greater than" and "less than" should in many cases be "greater
than or equal to" and "less than or equal to".

The reason your original formula generates a 0 is because any single IF
that returns a zero multiplies every other zero or non-zero response by
zero, resulting in zero.