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
--
Paul Webster

Paul,

Use the "INT" function.

Steve



"Paul Webster" wrote in message
...
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
--
Paul Webster

"Paul Webster" wrote:
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" wrote in message
...
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
--
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


"JoeU2004" wrote:

"Paul Webster" wrote:
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" wrote in message
...
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
--
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


"Steve Yandl" wrote:

Paul,

Use the "INT" function.

Steve



"Paul Webster" wrote in message
...
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
--
Paul Webster