| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
rounding
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
rounding
Hi
AFAIK this is not really possible if you want the numbers to remain numeric values. I can only think about a macro solution "Jean-Paul De Winter" wrote: 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 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
rounding
The result is a "final resul" so nu further calculation is needed...
It's the % pupils get on their monthly report... JP "Frank Kabel" schreef in bericht ... Hi AFAIK this is not really possible if you want the numbers to remain numeric values. I can only think about a macro solution "Jean-Paul De Winter" wrote: 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 |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
rounding
Hi
1. One way to try (works for me): Format the target cell as 'General' and use a formula such as =ROUND(A1*2,0)/2 2. If this does not work try try =IF(ROUND(A1*2,0)/2=TRUNC(A1),TEXT(TRUNC(A1),"0"),TEXT(ROUND(A1*2,0)/2,"0.0") "Jean-Paul De WInter" wrote: The result is a "final resul" so nu further calculation is needed... It's the % pupils get on their monthly report... JP "Frank Kabel" schreef in bericht ... Hi AFAIK this is not really possible if you want the numbers to remain numeric values. I can only think about a macro solution "Jean-Paul De Winter" wrote: 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 |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
rounding
yep... thanks
JP "Frank Kabel" schreef in bericht ... Hi 1. One way to try (works for me): Format the target cell as 'General' and use a formula such as =ROUND(A1*2,0)/2 2. If this does not work try try =IF(ROUND(A1*2,0)/2=TRUNC(A1),TEXT(TRUNC(A1),"0"),TEXT(ROUND(A1*2,0)/2,"0.0" ) "Jean-Paul De WInter" wrote: The result is a "final resul" so nu further calculation is needed... It's the % pupils get on their monthly report... JP "Frank Kabel" schreef in bericht ... Hi AFAIK this is not really possible if you want the numbers to remain numeric values. I can only think about a macro solution "Jean-Paul De Winter" wrote: 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 |
|
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
rounding
On Tue, 26 Oct 2004 11:40:59 GMT, "Jean-Paul De Winter"
wrote: 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 Format the cell as "General". --ron |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| 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 | |||
Hybrid Mode
