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

Everyone has given you the IF function method, so let me be different.<g

=A1*AND(A1200,A1<300)

Rick