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

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

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

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

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

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