B
Bart
I have a worksheet that needs to calcualte automatically
depending on the date. The values needed are in columns
starting Oct-Sept. The columns Oct-Sept equal a certain
figure. There are charges per month that need to be
calculated based on the date but the totals should equal a
predetermined figure. For example, I have the following
formula =IF(AND(C48>Dec31,C48<Feb1),L16-SUM(E46:G46),IF
(C48<>jan,((M46-N46)-SUM(I46:K46,E46,F46,G46))))
If the date is within January then I need a certain range
added....once it hits February then I need that figure to
remain what it was the last day in January so I do not
lose sight of the January charges....
The same formula would then go in the February block. My
problem is I end up getting circular references. I realize
this was long winded and probably not explained well but
any help would be greatly appreciated. Thanks.
depending on the date. The values needed are in columns
starting Oct-Sept. The columns Oct-Sept equal a certain
figure. There are charges per month that need to be
calculated based on the date but the totals should equal a
predetermined figure. For example, I have the following
formula =IF(AND(C48>Dec31,C48<Feb1),L16-SUM(E46:G46),IF
(C48<>jan,((M46-N46)-SUM(I46:K46,E46,F46,G46))))
If the date is within January then I need a certain range
added....once it hits February then I need that figure to
remain what it was the last day in January so I do not
lose sight of the January charges....
The same formula would then go in the February block. My
problem is I end up getting circular references. I realize
this was long winded and probably not explained well but
any help would be greatly appreciated. Thanks.