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