M
mjv
I have a formula in an Excel spreadsheet that I need to convert into a MS
Access expression. The formula is =ROUNDUP(n*25.4,-1). If n=99 then
99*25.4=2514.6, I need to round this up to 2520, how? I entered the
following expression (10*CInt(Nz([n]*25.4,0)/10)) but if n=99 then 2510 is
calculated, but if n=114 then 2900 is calculated which is what I want. How
can I make it roundup all of the time?
Access expression. The formula is =ROUNDUP(n*25.4,-1). If n=99 then
99*25.4=2514.6, I need to round this up to 2520, how? I entered the
following expression (10*CInt(Nz([n]*25.4,0)/10)) but if n=99 then 2510 is
calculated, but if n=114 then 2900 is calculated which is what I want. How
can I make it roundup all of the time?