I am working on workbook trying to create a template for a friend. What I am trying to do is keep sheet1 as the finished sheet, and have sheets 2 & 3 as the informatin log sheets. Here is the formula that I started with: =IF('2009'!$B$2=20, 2*10,""). What he wants is to have sheet1 showing his clients, months, & totals. On sheet2 he wants to be able to input the amount of the payment every month in one cell (i.e. 20 for Jan, 40 for Feb, 60 for Mar., etc.). I have the formula above in the month of January, and have this for the remainder: =IF('2009'!$B$2=40, 40/2,"") this way on sheet1 all months show $20.00. The 40 is changed to 60 and 80 and so on for every month. Now to the question.
How can I use this formula and still keep sheet1 showing $20.00 for all months, no matter what the cell on sheet2 has in it, but the months that have not been paid yet show a zero balance?
Sorry, I want to help but I just don't get this at all.
The 2009 and 2010 tabs seem to be an accrued total payment.
So he would have to look in the relevant cell for the client and then add $20 to it if a new payment has come in - is that right? So, change $120 to $140. And then you want that reflected on Sheet1?
But how is that better for him than just having Sheet1 (remove the others) and just to type $20 in under the correct date?
Hopefully someone else understands this better and will be able to step in...