=IF(AND(A1200,A1<300),A1,0)

Regards

Trevor


"Ann" wrote in message
...
how do i do a if A1 200 and <300 return A1 otherwise return 0. i can't
get
the logic to work