My actual dataset is much more complicated, but hopefully this simplification will do the trick.

Let's say cells A1 and A2 are =randbetween(1,10), cell A3 is =5, cells B1 and B2 are =randbetween(1,11), and cell B3 is =6. Cell C1 is =A1+A2+A3, and cell C2 is =B1+B2+B3. C3 is =(C1-C2)/((C1+C2)/2), a type of percentage difference calculation. Every time I hit F9 the values in column C will of course be a different number.

I would like cell D1 to tell me how often C3.4, D2 to tell me how often .4C3=.2, D3 to tell me how often .2C3-.2, D4 to tell me how often -.2=C3-.4, and D5 to tell me how often C3<=-.4

There's a strong preference towards calculating the values of column D by only referencing column C, if at all possible.

Update: actual sheet and more details in subsequent posts