| Home |
| Search |
| Today's Posts |
|
|
|
#1
|
|||
|
|||
Rounding
I have several numbers that are actually the result of several AVERAGE
functions. How would I round these numbers UP to the nearest 0.05? Example: 34.66 to 34.70 32.23 to 32.25 etc. Thanks in advance Chris |
|
#2
|
|||
|
|||
|
=ROUND(AVERAGE(A1:A10),.05)
I think this will work. "Christopher Anderson" wrote: I have several numbers that are actually the result of several AVERAGE functions. How would I round these numbers UP to the nearest 0.05? Example: 34.66 to 34.70 32.23 to 32.25 etc. Thanks in advance Chris |
|
#3
|
|||
|
|||
|
Hi
Try =CEILING(A1,0.05) -- Andy. "Christopher Anderson" wrote in message ... I have several numbers that are actually the result of several AVERAGE functions. How would I round these numbers UP to the nearest 0.05? Example: 34.66 to 34.70 32.23 to 32.25 etc. Thanks in advance Chris |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Banker's Rounding - need help! | Excel Discussion (Misc queries) | |||
| Can I stop rounding in excel? | Excel Discussion (Misc queries) | |||
| How do I make Excel stop rounding off my numbers that are 16 digi. | Excel Discussion (Misc queries) | |||
| Rounding to the next highest 1000 after a resulting formula | Excel Worksheet Functions | |||
| rounding again | Excel Worksheet Functions | |||
Hybrid Mode
