Cool stuff. Thanks Gord Dibben, Thanks Ian.
--
Socrates said: I only know, I don''''t know nothing.
I say : I don''''t even know, I don''''t
know nothing.


"Ian" wrote:

=CEILING(A1,1)-A1

Ceiling rounds up to the next multiple, in this case 1.

Ian

"Learning Excel" wrote in message
...
Recently I sign up for a credit card offer and everytime I use it they
acredited the left over of the change into my account. In English :
If I spent $10.30 they acredit me .70 cents to my account ( what's left
for
the 11)
If I spent $ 11.10 they acredit me .90 cents and so on.
I have my check book on excell.
Let's say I have all spent in column A.
would it there be a formula to extract in B column each one of the left
over
change ? RESULTS :
A B

1 10.30 .70

2 11.10 .90 with the formula in B copy down. Thanks.

Socrates said: I only know, I don''''t know nothing.
I say : I don''''t even know, I don''''t
know nothing.