software

i hv a question...

Is there any formula in excel that can convert a certain number to a number
that is greater than the previous number, with the smallest difference which
is also an integer number? for example:23.56 convert to 24
24.00 convert to 25
23.12 convert to 24
19.00 convert to 20
42.10 convert to 43

HELP ME!!!

It looks like you could just add one and take the integer portion:

=int(a1 1)

If A1 held the original number.

nekteo wrote:
gt;
gt; i hv a question...
gt;
gt; Is there any formula in excel that can convert a certain number to a number
gt; that is greater than the previous number, with the smallest difference which
gt; is also an integer number? for example:
gt;
gt; 23.56 convert to 24
gt; 24.00 convert to 25
gt; 23.12 convert to 24
gt; 19.00 convert to 20
gt; 42.10 convert to 43
gt;
gt; HELP ME!!!

--

Dave Peterson

thank you very much!!!

Dave Peterson wrote:
gt;It looks like you could just add one and take the integer portion:
gt;
gt;=int(a1 1)
gt;
gt;If A1 held the original number.
gt;
gt;gt; i hv a question...
gt;gt;
gt;[quoted text clipped - 9 lines]
gt;gt;
gt;gt; HELP ME!!!
gt;