Jefferson Davis 12.May.11 07:56 PM a Web browser
1-2-3 All Releases Windows XP
Hello all,
I have this formula: @INDEX($P3_SUMS,2,@MATCH($I22,$P3_SUMS,0))
that calculates correctly if the "Sum Count" number is not a "0" (zero).
Cell $I22 contains a formula that can Sum "0" or greater.
The $P3_SUMS range is below:
SUM Counts = How Many Times?
0 = 1
1 = 3
2 = 6
3 = 10
4 = 15
5 = 21
6 = 28
7 = 36
8 = 45
9 = 55
10 = 63
11 = 69
12 = 73
13 = 75
14 = 75
15 = 73
16 = 69
17 = 63
18 = 55
19 = 45
20 = 36
21 = 28
22 = 21
23 = 15
24 = 10
25 = 6
26 = 3
27 = 1
I've tried several combinations of @ISEMPTY, @ISNUMBER, @CELL("contents";$I22)="b", etc. Nothing seems to work.
Is there a way to have this formula result in a "1" when the Sum Count ="0"?
As I said, the formula works if the Sum Count is greater than "0". Just not if it is a "0".
Thanks to anyone that has the time to look into this problem.
JD
 Formula to calculate "0" (zeros) (Jefferson Davis... 12.May.11)
 . . RE: Formula to calculate "0" (zeros... (Russ Bartoli 13.May.11)
. . . . RE: Formula to calculate "0" (zeros... (Jefferson Davis... 17.May.11)
. . RE: Formula to calculate "0" (zeros... (Jonathan Metzge... 13.May.11)
. . . . RE: Formula to calculate "0" (zeros... (Jefferson Davis... 18.May.11)
| 
Return to top
Print this page
