| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Round down if decimal 0.33 or below up if 0.34 or above
Better
=ROUND(A1+(1/6),0) "Pete_UK" wrote: Another one: =ROUND(A1+0.1699999,0) Hope this helps. Pete On Apr 23, 11:11 am, tennisnut wrote: Is there a formula that allows you to choose where to round up and down from. EG 1.33 = 1 and 1.34 = 2 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Calculate to the third decimal and round up or down in cell | Excel Worksheet Functions | |||
| how do i round decimal if 2.3=2.5 2.7=2.5 & 2.8=3.0 | Excel Worksheet Functions | |||
| Round a negative decimal | Excel Worksheet Functions | |||
| How do I round last number without a decimal point | Excel Worksheet Functions | |||
| ROUND DATA TO 2 DECIMAL PLACES | New Users to Excel | |||
Hybrid Mode
