Try this

=IF(AND(A1=VALUE(LEFT(A2,FIND("-",A2,1)-1)),A1<=VALUE(RIGHT(A2,LEN(A2)-FIND("-",A2,1)))),1,0)


Hope this helps.


Coltsfan Wrote:
Is there a formula that I can use that says if
Cell A1 which is 17 is equal to or between A2 which is 13-20 then 1
otherwise 0?

If anyone could help I would appreciate it.

thanks


--
Morrigan
------------------------------------------------------------------------
Morrigan's Profile: http://www.excelforum.com/member.php...fo&userid=7094
View this thread: http://www.excelforum.com/showthread...hreadid=391124