Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hi,
I found a way to round numbers like 6.4 to 6.5 The formula works just perfect but, rounding 6.2 returns 6.0 Is there a way to display only 6 instead of 6.0??? The problem is when I limit the decimal place to 0 I never get 6.5.... Thanks JP |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Rounding off | Excel Discussion (Misc queries) | |||
ROUNDING FORMULA =ROUND(B12/$B$10,1) ROUNDING TO HIGH | Excel Worksheet Functions | |||
Rounding up | Excel Worksheet Functions | |||
ROUNDING | Excel Worksheet Functions | |||
I need a formula with rounding up & rounding down to the nearest . | Excel Worksheet Functions |