| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How to round a number up or down
We use an Excel spreadsheet to calculate drug doses for our veterinary
surgical practice. Is there a way to format the cell to round up or down? I have tried using the round function but it does not work the way we need it to. Basically, if the number after the decimal point is greater than or equal to 5, we want it round up (or down, if need be). The only reason it matters is because we base other calculations on the worksheet on this calculation and it throws the rest of them off. |
| 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 | |||
Threaded Mode
