Keep the change

[Learning Excel]

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.

 

[Ian]

=CEILING(A1,1)-A1

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

Ian

 

[Gord Dibben]

=CEILING(A1,1)-A1 entered in B1


Gord Dibben MS Excel MVP

 

[Learning Excel]

Cool stuff. Thanks Gord Dibben, Thanks Ian.