Trying Rounding

[Guest]

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...

 

[joeu2004]

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...

But what should 6, 13, and 20 become? I have to ask because so many
people in this forum misuse the terms "round", "round down" and "round
up". Your subject line says "round" -- which means "round up or down
as appropriate" in my parlance -- but all of your examples say "round
down".

If you truly want to "round" (by my definition), try one of the
following:

=mround(A1, 7)

=7*round(A1/7, 0)

MROUND() requires that install and load the Excel Analysis ToolPak.
See the MROUND help page for instructions.

If you want to "round down" (always!), try the following:

=7*int(A1/7)

Note: These functions may not produce the desired results when A1
contains a negative number. If that is a concern, try them first and
make appropriate adjustments. Different individuals expect different
"desired results" for negative numbers.

 

[Guest]

=7*INT(A1/7)

 

[David Biddulph]

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.