Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Automatic Deduction?
Is there any way for Excel 2008 to automatic subtract an amount from another
number each month? Example A1 has a monthly payment of $500 A2 has the whole cost of $5,000 Is there a way for A2 to automaticly deduct the amount in A1 from the total amount in A2 and replace it with the new amount of $4,500. Then do the same each month automaticly? Trying to work on a Family Budget with Excel and I wanted to be able to have an estimate of the reminder of each Fixed Bill. Any ideas? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Automatic Deduction?
Enter 500 in A1
Enter 5000 in A2 Enter =TODAY() in B1 Enter =IF(DAY(B1)<1,"",A2-MONTH(B1)*A1) in A3 Alternative............... 500 in A1 =TODAY() in B1 =IF(DAY(B1)<1,"",5000-MONTH(B1)*A1) in A2 Gord Dibben MS Excel MVP On Thu, 9 Oct 2008 08:44:04 -0700, Matlock wrote: Is there any way for Excel 2008 to automatic subtract an amount from another number each month? Example A1 has a monthly payment of $500 A2 has the whole cost of $5,000 Is there a way for A2 to automaticly deduct the amount in A1 from the total amount in A2 and replace it with the new amount of $4,500. Then do the same each month automaticly? Trying to work on a Family Budget with Excel and I wanted to be able to have an estimate of the reminder of each Fixed Bill. Any ideas? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Automatic update of spreadsheet & automatic update between workboo | Excel Worksheet Functions | |||
how to setup an excel inventory that is a deduction | Setting up and Configuration of Excel | |||
how to setup an excel inventory that is a deduction | Excel Worksheet Functions | |||
Insurance Deduction Spreadsheet | Excel Discussion (Misc queries) | |||
How do I download a personal blank wage deduction sheet | Excel Worksheet Functions |