Between or Equal to

C

Coltsfan

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
 
M

Morrigan

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.
 
Top