What I need is a formula to answer the following.
if cell a1 is a number between 1-121 then I need the formula to output a 1 if not then a 0
I also need to know how to write it if cell a1 is a number between c3-1 to c3-96 need the same output a 1 or a 0