=IF(AND(A1=C1,A1<=D1),E1,0)

and

=IF(AND(A1=.002,A1<=.039),E1,0)

--

HTH

RP
(remove nothere from the email address if mailing direct)


"sanpanico" wrote in message
...
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")