Greater than, smaller 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 a number
that is greater than the previous number, which is 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
|