my round formula rounds up too far

[coach_z]

Hello, welcome and nice board you have here. i have used it a bit but this is the first time i needed to ask a question.

my question:
I have this formula:
=(IF(SUM(G22:AG22),ROUND(SUM(G22:AG22)/$G$19,2),""))

which was made from a gradebook template that i am using for my girlfriend but the problem is that it rounds everything to the nearest whole number. (75.00%) we need it to show up as (75.23%)

Thank you very much for your help
-chris

 

[onlyadrafter]

Hello,

try

=(IF(SUM(G22:AG22),ROUND(SUM(G22:AG22)/$G$19,4),""))

 

[jproffer]

=(if(sum(g22:ag22),round((sum(g22:ag22)/$g$19),2),""))

 

[coach_z]

onlyadrafter thank you!
that has helped a lot, i tweeked it a little bit to get me an extra decimal.
excel was giving me 74.80 as the average, but it is actually 74.7967
i changed that 4 at the end of your formula to a 5 and formatted the cell for 3 decimal places.

Thank you!!