| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Rounding up or down decimals to the nearest 5
Hi
what formula can I use to round up a number with decimals to the nearest 5? eg 368.10 would be 370 367.00 would be 370 366.20 would be 370 364.12 would be 365 361.42 would be 365 I tried using various combinations of round, roundup and mround, but can't seem to get it right... thanks in advance! |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Rounding up or down decimals to the nearest 5
try this
suppose u have value in A1 then in B1 put this formula =CEILING(A1,5) On Oct 7, 12:43*pm, Michelle Wong wrote: Hi what formula can I use to round up a number with decimals to the nearest 5? eg 368.10 would be 370 367.00 would be 370 366.20 would be 370 364.12 would be 365 361.42 would be 365 I tried using various combinations of round, roundup and mround, but can't seem to get it right... thanks in advance! |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Rounding up or down decimals to the nearest 5
thanks! yes that worked great
"muddan madhu" wrote: try this suppose u have value in A1 then in B1 put this formula =CEILING(A1,5) On Oct 7, 12:43 pm, Michelle Wong wrote: Hi what formula can I use to round up a number with decimals to the nearest 5? eg 368.10 would be 370 367.00 would be 370 366.20 would be 370 364.12 would be 365 361.42 would be 365 I tried using various combinations of round, roundup and mround, but can't seem to get it right... thanks in advance! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Rounding up or down to the nearest $.09 | Excel Discussion (Misc queries) | |||
| rounding decimals to nearest quarter | Excel Worksheet Functions | |||
| Rounding to nearest 9 | Excel Worksheet Functions | |||
| I need a formula with rounding up & rounding down to the nearest . | Excel Worksheet Functions | |||
| Rounding results to nearest quarter (in decimals) | Excel Discussion (Misc queries) | |||
Hybrid Mode
