Int function

[pedie]

Is the opposite ofint '=INT(J9)+1?

 

[Jonmo1]

It depends on your definition of opposite...

To Me, INT returns the value to the left of the decimal..
I would think the opposite of that is to return the value to the right of the decimal..

=MOD(J9,1)

However, with Negative values, INT seems to round down, so INT(-2.3) would be -3


Hope that helps.

 

[dave3009]

Do you mean just return the decimals?

=J9-INT(J9)

 

[pedie]

Thanks guys...I want higher value...without points

 

[treesloth]

So, in effect, you want to round up? The usual trick is:

=INT(J9)+.5

But that should have the same effect as your original post. Or:

=CEILING(J9,1)

Which says, "Round up to the nearest multiple of 1". Ceiling is a nifty function...

 

[Jonmo1]

Then =INT(J9)+1 will work just fine..

Or perhaps
=ROUNDUP(J9,0)
Or
=CEILING(A1,1)

 

[shg]

Maybe ...

=ceiling(j9, 1)

=roundup(j9, 0)

EDIT: =INT(j9)+1 will convert an integer to the next higher integer.

 

[pedie]

Perfect, thanks again....