Greater than formula!
 

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!!!

Greater than formula!
 

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

=int(a1+1)

If A1 held the original number.

nekteo wrote:

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!!!

--

Dave Peterson

Greater than formula!
 

thank you very much!!!

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

=int(a1+1)

If A1 held the original number.

i hv a question...

[quoted text clipped - 9 lines]

HELP ME!!!