Rounding an average to the nearest 0.5
Solved
NôOrà h
Posted messages
2
Status
Membre
-
NôOrah -
NôOrah -
Hello,
In a university IT assignment, I have an exercise on Excel where I need to round up the average to the nearest 0.5 (for example, if we have 14.2 the rounding is 14.5 and if it’s 14.8 the rounding is 15). I used the formula ROUNDUP(AVERAGE(L3;G3);0.5) but it doesn’t work, it rounds to whole numbers (for example, 10.2 it puts 11 instead of 10.5). What should I do, please??
Configuration: Windows 8 / Chrome 26.0.1410.64
In a university IT assignment, I have an exercise on Excel where I need to round up the average to the nearest 0.5 (for example, if we have 14.2 the rounding is 14.5 and if it’s 14.8 the rounding is 15). I used the formula ROUNDUP(AVERAGE(L3;G3);0.5) but it doesn’t work, it rounds to whole numbers (for example, 10.2 it puts 11 instead of 10.5). What should I do, please??
Configuration: Windows 8 / Chrome 26.0.1410.64
Check if the data is indeed numeric and if the decimal separator is correct: does a simple formula with Average or Sum work?
Have the references been adjusted?