Help again please.
I have this formula in H14: IF(I14=0,0,(SUM($I$8:$I$13)/COUNTIF($I$8:$I$13,"<>0"))) which works great from help received on this forum.
Now, I need to round the answer to the nearest .25 in cell H15. I want to see the number above in H14 and the new rounded number (score) in cell H15.
Example: My answer for the above using numbers 0, 0, 0, 1, 2, 2 = 1.67.
I need to round this number to 1.75, but, the answer could also be a negative number if the numbers were to change to 0, 0, 0, -2, -2, 2 = negative 0.67, and I would want this rounded to negative .75.
Any formula you could provide me would be helpful. I again have searched the board but am now even more confused as to use round, a formula in cell H15 such as ceiling or ?. I can get ceiling to work but, does not work in both cases ie returns an error #num if negative.
Thank you in advance for your help.
I have this formula in H14: IF(I14=0,0,(SUM($I$8:$I$13)/COUNTIF($I$8:$I$13,"<>0"))) which works great from help received on this forum.
Now, I need to round the answer to the nearest .25 in cell H15. I want to see the number above in H14 and the new rounded number (score) in cell H15.
Example: My answer for the above using numbers 0, 0, 0, 1, 2, 2 = 1.67.
I need to round this number to 1.75, but, the answer could also be a negative number if the numbers were to change to 0, 0, 0, -2, -2, 2 = negative 0.67, and I would want this rounded to negative .75.
Any formula you could provide me would be helpful. I again have searched the board but am now even more confused as to use round, a formula in cell H15 such as ceiling or ?. I can get ceiling to work but, does not work in both cases ie returns an error #num if negative.
Thank you in advance for your help.