Between values

[Guest]

I am creating a formula in excel - an IF statement and I want the formula to
recognize if the number in a specific cell is between 0 and 50. How do I
build that into an IF statement?

Here is my example:
IF(B3 is greater than zero but less than 50, 1.00, 0)

 

[BrianB]

=if(and(b3>0,b3<50),1,0

 

[Alan]

=IF(AND(B3>0,B3<50),1.00,0)