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

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

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

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

I hope this is not confusing but what is displayed as the final rating for A2
depends on if it falls between the values in B2 and C2 or B3 and C3
respectively

for instance

A2 = 10

B2 = 5
C2 = 20
D2 = 7

So since A2 falls between B2 and C2 the rating for A2 would equal 7 because
that is the respective rating.

but if A2 = 50

B3 = 21
C3 = 55
D3 = 12

then the rating for A2 would be 12 since it falls between B3 and C3.

Thanks


"Barb Reinhardt" wrote:

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