D
Diane
I have a formula in cell C7, the formula is:
CORREL(B4:B6,C4:C6)
The cells have the follwing values:
B4: 1.90
B5: 1.90
B6: 1.90
C4: 2.13
C5: 1.83
C6: 3.02
Cell C7 returns: 0.000
Here's where the problem comes in.
The formula in cell C15 is: CORREL(B12:B14,C12:C14)
The cells have the follwing values:
B12: 9.50
B13: 9.50
B14: 9.50
C12: 9.56
C13: 10.26
C13: 10.16
Cell C15 returns the error: #DIV/0!
Why is the formula producing the #DIV/0! error in the
second set and not the first or vice versa?
ANY help would be greatly appreciated.
Thanks, Diane
CORREL(B4:B6,C4:C6)
The cells have the follwing values:
B4: 1.90
B5: 1.90
B6: 1.90
C4: 2.13
C5: 1.83
C6: 3.02
Cell C7 returns: 0.000
Here's where the problem comes in.
The formula in cell C15 is: CORREL(B12:B14,C12:C14)
The cells have the follwing values:
B12: 9.50
B13: 9.50
B14: 9.50
C12: 9.56
C13: 10.26
C13: 10.16
Cell C15 returns the error: #DIV/0!
Why is the formula producing the #DIV/0! error in the
second set and not the first or vice versa?
ANY help would be greatly appreciated.
Thanks, Diane