Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Average rounded to nearest 0.50
How do I round an average of three numbers down to the nearest 0.50
assuming the three numbers are in cells a1, b1, and c1 and the formula will be in cell d1. Also, how do I do the same but round up to the nearest 0.50. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
show fractions rounded up to nearest 1/16th inch | Excel Discussion (Misc queries) | |||
Allocated amount rounded to nearest .25 without exceeding total | Excel Worksheet Functions | |||
why is answer rounded up? | Excel Discussion (Misc queries) | |||
ROUNDED NUMBERS | Excel Worksheet Functions | |||
Ensuring input is rounded up to nearest 10 | Excel Discussion (Misc queries) |