| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Keep the change
=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. |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Keep the change
=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. |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Keep the change
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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| change scaling % but font size didnt change porportionally, pls he | Excel Discussion (Misc queries) | |||
| Excel bar chart formatting of bars to change colors as data change | Excel Discussion (Misc queries) | |||
| Use date modified to change format & create filter to track change | Excel Worksheet Functions | |||
| change info in other cells when i change a number in a drop list? | Excel Discussion (Misc queries) | |||
| Change workbook sheet reference using cell A1 to change a vairable | Excel Worksheet Functions | |||
Linear Mode
