Hi,
I have a formula that reads from a cell based on the month we are in. the cell it reads from is a constantly changing figure throughout the course of the month.
=IF(C3=MONTH(TODAY()), $C$16)
The formula works perfectly fine, however, the problem lies when we move to the next month, the figures will become false for September.
I need to somehow retain the last figure of the month so the chart that runs off this doesn't keep zeroing itself.
<colgroup><col><col><col span="10"><col></colgroup><tbody></tbody>
<colgroup><col><col span="10"><col></colgroup><tbody>
</tbody>
I keep ending up with circular references or just a broken formula in various different ways.
Any help is greatly appreciated
I have a formula that reads from a cell based on the month we are in. the cell it reads from is a constantly changing figure throughout the course of the month.
=IF(C3=MONTH(TODAY()), $C$16)
The formula works perfectly fine, however, the problem lies when we move to the next month, the figures will become false for September.
I need to somehow retain the last figure of the month so the chart that runs off this doesn't keep zeroing itself.
<colgroup><col><col><col span="10"><col></colgroup><tbody></tbody>
9 | 10 | 11 | 12 | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 |
September | October | November | December | January | February | March | April | May | June | July | August |
0 | FALSE | FALSE | FALSE | FALSE | FALSE | FALSE | FALSE | FALSE | FALSE | FALSE | FALSE |
7 | FALSE | FALSE | FALSE | FALSE | FALSE | FALSE | FALSE | FALSE | FALSE | FALSE | FALSE |
0 | FALSE | FALSE | FALSE | FALSE | FALSE | FALSE | FALSE | FALSE | FALSE | FALSE | FALSE |
<colgroup><col><col span="10"><col></colgroup><tbody>
</tbody>
I keep ending up with circular references or just a broken formula in various different ways.
Any help is greatly appreciated