Home |
Search |
Today's Posts |
#1
|
|||
|
|||
need help creating a formula
I am wanting to create a formula that will allow me to make deductions in my
budget until a specific amount is reached then it will no longer make deductions for that field. ex: my mortgage payment is 1150. so when I enter in our paycheck amounts I want the cell to make deductions based on the percentage we have assigned until it meets the 1150. Once it reaches the 1150 it will no longer make this deduction and skip the cell going to the next one. If anyone can help I would appreciate it Matt |
#2
|
|||
|
|||
Hi Matt
This should be fairly easy to achieve, but we need more information on the layout of your table. You need to be keeping track somewhere of the cumulative payments made to compare with 1150. Regards Roger Govier Matt wrote: I am wanting to create a formula that will allow me to make deductions in my budget until a specific amount is reached then it will no longer make deductions for that field. ex: my mortgage payment is 1150. so when I enter in our paycheck amounts I want the cell to make deductions based on the percentage we have assigned until it meets the 1150. Once it reaches the 1150 it will no longer make this deduction and skip the cell going to the next one. If anyone can help I would appreciate it Matt |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
adding row to forumla | Excel Discussion (Misc queries) | |||
Creating charts from formula results | Excel Discussion (Misc queries) | |||
Creating a specific formula | New Users to Excel | |||
Help with creating Formula again | Excel Worksheet Functions | |||
IF & VLOOKUP FORMULA | Excel Worksheet Functions |