rounding numbers
 

How can I round 3.4 to 3.5 instead of 3.0 or 4.0?

rounding numbers
 

Use
=MROUND(3.4,0.5)
Where 3.4 can also be the cell refernce.

"VPHR" wrote:

How can I round 3.4 to 3.5 instead of 3.0 or 4.0?

rounding numbers
 

Note that MROUND requires the Analysis ToolPac to be installed
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"Cin" wrote in message
...
Use
=MROUND(3.4,0.5)
Where 3.4 can also be the cell refernce.

"VPHR" wrote:

How can I round 3.4 to 3.5 instead of 3.0 or 4.0?

rounding numbers
 

=CEILING(A1,0.5)

"VPHR" wrote:

How can I round 3.4 to 3.5 instead of 3.0 or 4.0?

rounding numbers
 

Try:

=ROUND(A1*2,0)/2
or
=INT(A1*2+0.5)/2

--
HTH

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings


with @tiscali.co.uk


"VPHR" wrote in message
...
How can I round 3.4 to 3.5 instead of 3.0 or 4.0?