=IF(AND(A1<=$B$1,A1=$C$1),$D$1,0)

copy down to get A2 and so on


--


Regards,


Peo Sjoblom



"edm1007" wrote in message
...
I have a spreadsheet and I am needing help manipulating the data.

Example

A1 = 22
A2 = -55

other columns

B1 = 10
C1 = -119
D1 = E4

In last column, if A1 is between B1 and C1 then display the value of D1,
if
not then zero.
if A2 is between B1 and C1 then display the value of D1, if not then zero.

And so on........what is the best way to do this??????????