if statement between values
 

how do i enter this as a formula?

if r46 is between 37987 and 38017 then 1 else 0

thanks for any help

=IF(AND(R4637987,R46<38017),1,0)

Vaya con Dios,
Chuck, CABGx3


"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

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