And what exactly is it you want to do with B2, C2, B3 and C3 with respect to
A1?
--
HTH,
Barb Reinhardt




"edm1007" wrote:

If I also have values in B2 , C2 , B3 and C3 to take into consideration when
looking at A1, how would I do that?

"Peo Sjoblom" wrote:

=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??????????