| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
rounding down
I'm looking for help with a formula. I want to round down
to the nearest integer. For example, 4.1, 4.5, and 4.9 should all round down to 4. I can find how to round but not how to round down. Thanks for the help. |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
rounding down
Use the INT or TRUNC formula
Both return the next lowest integer. The only difference between the is when dealing with negative integers. If Cell A1 has 4.5 in it put TRUNC(A1) in B1 and you'll get -- Message posted from http://www.ExcelForum.com |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
rounding down
use the =ROUNDDOWN(,0)
"JT" wrote: I'm looking for help with a formula. I want to round down to the nearest integer. For example, 4.1, 4.5, and 4.9 should all round down to 4. I can find how to round but not how to round down. Thanks for the help. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| ROUNDING FORMULA =ROUND(B12/$B$10,1) ROUNDING TO HIGH | Excel Worksheet Functions | |||
| Rounding Up | Excel Worksheet Functions | |||
| I need a formula with rounding up & rounding down to the nearest . | Excel Worksheet Functions | |||
| Rounding off to .48 or .98 | Excel Discussion (Misc queries) | |||
| Rounding | Excel Worksheet Functions | |||
![JT[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Hybrid Mode
