ExcelBanter - Rounding a number down to the nearest 5?

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Rounding a number down to the nearest 5? (https://www.excelbanter.com/excel-worksheet-functions/9229-rounding-number-down-nearest-5-a.html)

maluli

Rounding a number down to the nearest 5?

I want to be able to have numbers in excel round down to nearest 5. Example
296 down to 295 or 294 down to 290.

Peo Sjoblom

One way

=FLOOR(A1,5)

Regards,

Peo Sjoblom

"maluli" wrote:

I want to be able to have numbers in excel round down to nearest 5. Example
296 down to 295 or 294 down to 290.

maluli

That works perfectly. Thanks for you input Peo!!

"Peo Sjoblom" wrote:

One way

=FLOOR(A1,5)

Regards,

Peo Sjoblom

"maluli" wrote:

I want to be able to have numbers in excel round down to nearest 5. Example
296 down to 295 or 294 down to 290.

Peo Sjoblom

My pleasure, thanks for the thanks

Regards,

Peo Sjoblom

"maluli" wrote:

That works perfectly. Thanks for you input Peo!!

"Peo Sjoblom" wrote:

One way

=FLOOR(A1,5)

Regards,

Peo Sjoblom

"maluli" wrote:

I want to be able to have numbers in excel round down to nearest 5. Example
296 down to 295 or 294 down to 290.

All times are GMT +1. The time now is 12:13 AM.