| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to round up a number?
Does anyone have any suggestions on how to round up a number? such as
If the value in cell A1 is 3, then return 3, but If the value in cell A1 is 3.1, then round it up to 4. Does anyone have any suggestions? Thank in advance Eric |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How to round up a number?
Take a look at =roundup() in excel's help.
=roundup(a1,0) Eric wrote: Does anyone have any suggestions on how to round up a number? such as If the value in cell A1 is 3, then return 3, but If the value in cell A1 is 3.1, then round it up to 4. Does anyone have any suggestions? Thank in advance Eric -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Round number to the thousands without changing underlying number | Excel Discussion (Misc queries) | |||
| Excel. How to round a number to nearest half number? | Excel Discussion (Misc queries) | |||
| Can I increase a number by 5.5% and then round that number to the. | Excel Discussion (Misc queries) | |||
| How can i round a number to closest tenth number? | Excel Worksheet Functions | |||
| How to make a number round up/down to a set number | Excel Worksheet Functions | |||
Linear Mode
