if statement between values

[Qaspec]

how do i enter this as a formula?

if r46 is between 37987 and 38017 then 1 else 0

thanks for any help

 

[CLR]

=IF(AND(R46>37987,R46<38017),1,0)

Vaya con Dios,
Chuck, CABGx3

 

[Ragdyer]

Try this if you really mean *between* 37987 & 38017:

=(R46>37987)*(R46<38017)

If you want to *include* 37987 & 38017, try this:.

=(R46>=37987)*(R46<=38017)