Rounding Downward? 2

[NumberCrunchingMonky]

It seems that Excel rounds upward by default at the .5 point in a whole integer. Is there a non-formula way (or non special format way) to get it to round downward at .5 (and below)? So, any increment above .5 would round upward; but any increment at .5 and less would round downward to the nearest whole integer.

Thanks,

NCM

 

[SkipVought]

Hi,

How 'bout
[tt]
=INT(nbr+.5)
[/tt]
???

Skip,

Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884

 

[fredericofonseca]

Maybe

rounddown

Syntax

ROUNDDOWN(number,num_digits)

Number is any real number that you want rounded down.

Num_digits is the number of digits to which you want to round number.


Regards

Frederico Fonseca
SysSoft Integrated Ltd

http://www.syssoft-int.com

 

[fredericofonseca]

Oops.
That ALWAYS rounds down. No good.



Regards

Frederico Fonseca
SysSoft Integrated Ltd

http://www.syssoft-int.com

 

[NumberCrunchingMonky]

Good solutions--thanks!

NCM

 

[AnotherHiggins]

NCM,

I realize that you've already accepted both answers offered, but Skip's suggestion is off by .1! You specifically asked to make Excel round down at x.5, and up at x.6 - Skip's formula will still round up at .5

What you want is:

=INT(A1+.4)
where A1 contains the number to be rounded

This should accomplish what you asked.

Hope that helps,
John