Round up based on pre-defined integers

  • Thread starter Thread starter Shlandy
  • Start date Start date
S

Shlandy

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

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

HTH
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

IF and Round 5
Round Function 5
Formula help - rounding up and round down? 2
Set non-continuous PrintArea via Function / Name 0
Formula help 3
Access stripping decimal places in query 1
How to round a number up or down 3
How to round & sum only the displayed (rounded) numbers 2

Back
Top