|
NC Indiana | If you're just wanting to have a running total of your car payment in a seperate table/ledger, then yes I believe this can be done w/ a lookup command and an if command to keep it totalling. You would have to write these formulas in the table/ledger you wish them to appear and each payment would need to be coded individually, say "car pmt 1" through "car pmt 48" for a 48 month note. Each formula in the receiving worksheet would need to be numbered individually to match a seperate payment. I would also name the checkbook ledger to save on typing and for future data work. W/o actually working through it, I'm thinking you'll have something a long the lines of if(vlookup(x,y)>0,vlookup(x,y),""). | |
|
Excel Question
