How could I write a function that would return a number in one cell, if a
number in another cell falls between a certain range?

(if A1 is between C1:D1 then E1, else "0")
(if .23 is between .039:.002 then 15, else "0")