| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Rounding
How can I round 58 up to 60?
|
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Rounding
=ROUND(C19/10,0)*10
where C19 contains the value 58 "Grant" wrote: How can I round 58 up to 60? |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Rounding
One way:
=ROUND(58,-1) Another: =ROUNDUP(58,-1) Another: =CEILING(58,10) In article , "Grant" wrote: How can I round 58 up to 60? |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Rounding
Just another way:
=CEILING(C19,10) -- HTH Sandy In Perth, the ancient capital of Scotland and the crowning place of kings with @tiscali.co.uk "Grant" wrote in message ... How can I round 58 up to 60? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| rounding help | Excel Discussion (Misc queries) | |||
| Rounding .01 to 1 instead of 0 | Excel Discussion (Misc queries) | |||
| Rounding or not rounding | Excel Worksheet Functions | |||
| Rounding | Excel Worksheet Functions | |||
| Rounding | Excel Discussion (Misc queries) | |||
Linear Mode
