| 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. |
| 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 | |||
Threaded Mode
