ExcelBanter - Round up based on pre-defined integers

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

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

- - Round up based on pre-defined integers (https://www.excelbanter.com/excel-worksheet-functions/182422-round-up-based-pre-defined-integers.html)

Shlandy

Round up based on pre-defined integers

I was wondering if there was a function to round up/down to the next variable
pre-defined number, based on a table? I am trying to do this with out using
the if/then statements.

pdberger

Round up based on pre-defined integers

Shlandy --

Depending on what you're trying to do, I'd look at "MROUND", "CEILING", and
"FLOOR".

HTH

"Shlandy" wrote:

I was wondering if there was a function to round up/down to the next variable
pre-defined number, based on a table? I am trying to do this with out using
the if/then statements.

All times are GMT +1. The time now is 03:43 AM.