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

=(R4637987)*(R46<38017)

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

=(R46=37987)*(R46<=38017)
--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------


"Qaspec" wrote in message
...
how do i enter this as a formula?

if r46 is between 37987 and 38017 then 1 else 0

thanks for any help