Ann

=if(and(A1200,A1<300),A1,0)

is one way.

Good luck.

Ken
Norfolk, Va


On Jun 25, 4:18 pm, Ann wrote:
how do i do a if A1 200 and <300 return A1 otherwise return 0. i can't get
the logic to work