format

[cmccabe]

I have an excel 2010 formula set to =(AVERAGE(C27:E27)*100)/20 and the format of the result is set to number no decimal. It works for most of the cells but a few of them are incorrect and upon evaluation of the formula I see that the result is in the format x.xx and leads to an incorrect calculation. How can I fix this? Thanks.

 

[FormR]

You could try:

=ROUND(AVERAGE(C27:E27)*100/20,0)

 

[Robert Mika]

I have an excel 2010 formula set to =(AVERAGE(C27:E27)*100)/20 and the format of the result is set to number no decimal. It works for most of the cells but a few of them are incorrect and upon evaluation of the formula I see that the result is in the format x.xx and leads to an incorrect calculation. How can I fix this? Thanks.

What's the incorection are?
BTW
Yuo do not need parathesis here:

=AVERAGE(C27:E27)*100/2