Rounding
 

I am looking for a rounding function that for a given set up number will
round each number to the nearest 5 increment. i.e. 1142.68,1268.05,1298.22 i
would like rounded to 1140,1270 and 1300. I tried the =round() function but
that just took off the decimals.

Rounding
 

Try this:

=ROUND(INT(A1)/5,0)*5



--
Biff
Microsoft Excel MVP


"Jase" wrote in message
...
I am looking for a rounding function that for a given set up number will
round each number to the nearest 5 increment. i.e. 1142.68,1268.05,1298.22
i
would like rounded to 1140,1270 and 1300. I tried the =round() function
but
that just took off the decimals.

Rounding
 

Try this...

=round(a1/5, 0) * 5
--
HTH...

Jim Thomlinson


"Jase" wrote:

I am looking for a rounding function that for a given set up number will
round each number to the nearest 5 increment. i.e. 1142.68,1268.05,1298.22 i
would like rounded to 1140,1270 and 1300. I tried the =round() function but
that just took off the decimals.

Rounding
 

What is the purpose to using the int function?
--
HTH...

Jim Thomlinson


"T. Valko" wrote:

Try this:

=ROUND(INT(A1)/5,0)*5



--
Biff
Microsoft Excel MVP


"Jase" wrote in message
...
I am looking for a rounding function that for a given set up number will
round each number to the nearest 5 increment. i.e. 1142.68,1268.05,1298.22
i
would like rounded to 1140,1270 and 1300. I tried the =round() function
but
that just took off the decimals.

Rounding
 

Just a question/clarification...

Did you really want 1142.68 to round down to 1140?

Or did you want it to round up to 1145.

There's a difference in what Biff and Jim suggested.



Jase wrote:

I am looking for a rounding function that for a given set up number will
round each number to the nearest 5 increment. i.e. 1142.68,1268.05,1298.22 i
would like rounded to 1140,1270 and 1300. I tried the =round() function but
that just took off the decimals.

--

Dave Peterson

Rounding
 

1142.68...would like rounded to 1140

=ROUND(A1/5,0)*5 = 1145

=ROUND(INT(A1)/5,0)*5 = 1140

I wan't sure how they wanted to treat the original value, either drop the
decimal or round to the nearest integer. If you round to the nearest int
then 1142.68 = 1143 rounded to the nearest 5 = 1145.

So, if they *want* 1140 then you have to drop the decimal.



--
Biff
Microsoft Excel MVP


"Jim Thomlinson" wrote in message
...
What is the purpose to using the int function?
--
HTH...

Jim Thomlinson


"T. Valko" wrote:

Try this:

=ROUND(INT(A1)/5,0)*5



--
Biff
Microsoft Excel MVP


"Jase" wrote in message
...
I am looking for a rounding function that for a given set up number will
round each number to the nearest 5 increment. i.e.
1142.68,1268.05,1298.22
i
would like rounded to 1140,1270 and 1300. I tried the =round() function
but
that just took off the decimals.

Rounding
 

Ding! I figured it out. I didn't notice that 1142.68 rounded down to 1140.
Dave's post clued me in to it...
--
HTH...

Jim Thomlinson


"Jim Thomlinson" wrote:

What is the purpose to using the int function?
--
HTH...

Jim Thomlinson


"T. Valko" wrote:

Try this:

=ROUND(INT(A1)/5,0)*5



--
Biff
Microsoft Excel MVP


"Jase" wrote in message
...
I am looking for a rounding function that for a given set up number will
round each number to the nearest 5 increment. i.e. 1142.68,1268.05,1298.22
i
would like rounded to 1140,1270 and 1300. I tried the =round() function
but
that just took off the decimals.

Rounding
 

=MROUND(A2,5)
If it gives you a #NAME! error, look up MROUND in Excel help.
--
David Biddulph

"Jase" wrote in message
...
I am looking for a rounding function that for a given set up number will
round each number to the nearest 5 increment. i.e. 1142.68,1268.05,1298.22
i
would like rounded to 1140,1270 and 1300. I tried the =round() function
but
that just took off the decimals.