View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
pdberger pdberger is offline
external usenet poster
 
Posts: 258
Default 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.