S
steve
Hi,
I'm looking to return a result of blank, 1, or -1, depending on the
value of another cell. Here's what I have so far:
=IF((ISBLANK(A1),"",(IF((AND(ISNUMBER(A1),(IF(A1>SQRT(AVERAGE(A$1:A
$54))),1,-1)))
What I want to do is:
- If the cell A is blank, cell B should be blank
- If cell A is a number then I want to check to see if the cell is
greater than the square root of the average of column A.
- If cell A is greater than the square root of the averages of column
A than cell B should be 1.
- If cell B is less than the square root of the average of column A
than cell B should be -1.
What I originally was using was:
=IF((AND(ISBLANK(A1))),"",(IF((A1>SQRT(AVERAGE(A$1:A$54))),1,-1)))
The problem I ran into was that if cell A1 and A2 were both zero than
column b would result as -1 since it was false.
What am I missing?
I'm looking to return a result of blank, 1, or -1, depending on the
value of another cell. Here's what I have so far:
=IF((ISBLANK(A1),"",(IF((AND(ISNUMBER(A1),(IF(A1>SQRT(AVERAGE(A$1:A
$54))),1,-1)))
What I want to do is:
- If the cell A is blank, cell B should be blank
- If cell A is a number then I want to check to see if the cell is
greater than the square root of the average of column A.
- If cell A is greater than the square root of the averages of column
A than cell B should be 1.
- If cell B is less than the square root of the average of column A
than cell B should be -1.
What I originally was using was:
=IF((AND(ISBLANK(A1))),"",(IF((A1>SQRT(AVERAGE(A$1:A$54))),1,-1)))
The problem I ran into was that if cell A1 and A2 were both zero than
column b would result as -1 since it was false.
What am I missing?