ROUNDING DOWN

[Paul Webster]

Hi,

I want to round down a calculation such as =SUM(D6)-(D6*15%) so that no
matter what the decimal value is it will always round down.

Any assistance wuld be appreciated

 

[Steve Yandl]

Paul,

Use the "INT" function.

Steve

 

[JoeU2004]

I want to round down a calculation such as =SUM(D6)-(D6*15%) so
that no matter what the decimal value is it will always round down.

Round down to what: an integer number?

If so, use one of the following:

=INT(D6-D6*15%)

=ROUNDDOWN(D6-D6*15%,0)

They differ when rounding down negative numbers. For example, INT(-1.5)
is -2, whereas ROUNDDOWN(-1.5,0) is -1.

PS: You probably do not need to use SUM. It would be useful only if D6
might be "" (null string). But in that case, N(D6) would be more
straight-forward (less likely to evoke disapproving comments), and
=N(D6)*(1-15%) would be more correct.


----- original message -----

 

[Paul Webster]

Thanks Joe,

I tried both INT and ROUNDDOWN and they both work a treat - I have chosen to
go with ROUNDDOWN as it is self explanatory when I look at it again in the
future - once again thanks

 

[Paul Webster]

Thanks Steve,

I tried both INT and ROUNDDOWN and they both worked a treat, however, I have
chosen to go with ROUNDDOWN as it is self explanatory when I look at it again
in the future - old age and bad memory!!. once again thanks - its people like
you that make things easier for people like me keep up the good work

Paul