But does it work for 2.9?

--

HTH

Bob Phillips

"Thomas" wrote in message ...
How about,
var = CLng(2.1) + 1



Bob Phillips wrote:

or without worksheet formulae

myVar = (2.1+1)*10\10

--

HTH

Bob Phillips

"LSB" wrote in message
...
I would like to use this function in my macro. As I found
this function in the Excel Help, but when I use it in
thecoding it prompts me the error message 'Sub or Function
not Defined'. I would like to know how can I work on this
error.
Actually I want to round up my figure, for example

2.1 roundup to 3
3.5 roundup to 4
6.9 roundup to 7

Ccan please somebody help me on this. Thanks in advance.