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