"Nicholas" wrote in message
...
I need to rounddown values to the nearest 7 multiple.
They will always be whole numbers.

If I have a number of 8 it needs to round down to 7.
If I have a number of 9 it needs to round down to 7.
If I have a number of 15 it needs to round down to 14.
etc...

=7*INT(A1/7)

There remain the usual questions as to how you would want to treat negative
numbers, & decide whether you want INT or TRUNC.
--
David Biddulph