| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
rounding
I'm trying to round resources down if they are less than .5, up if greater
than a .5, and also equal to 1 if less than .5. For example 1.2 = 1, & 1.6 = 2, .4 = 1. My formula is = round(AB23/AB36,0), but less than .5 = 0 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I correct rounding errors in Excel formulas? | Excel Worksheet Functions | |||
| Significant number rounding based on key cell | Excel Worksheet Functions | |||
| Problems: rounding & formatting Text/# combinations | Excel Discussion (Misc queries) | |||
| Rounding to the Nearest Eighth | Excel Discussion (Misc queries) | |||
| Banker's Rounding - need help! | Excel Discussion (Misc queries) | |||
Threaded Mode
