Thread: Keep the change
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Learning Excel Learning Excel is offline
external usenet poster
 
Posts: 98
Default Keep the change

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.