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


Gord Dibben MS Excel MVP


On Sun, 4 Nov 2007 10:52:03 -0800, Learning Excel
wrote:

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.