rounding

[Jean-Paul De Winter]

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

 

[Guest]

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]

The result is a "final resul" so nu further calculation is needed...
It's the % pupils get on their monthly report...
JP

 

[Guest]

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]

yep... thanks
JP

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"
)

 

[Ron Rosenfeld]

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