Good afternoon,
I want to make an auto increment in my cell formula. The idea is every time I put a check mark , it will increase by 1.
For example:[TABLE="width: 547"]
<colgroup><col><col><col><col><col></colgroup><tbody>[TR]
[TD]
10/16-12/16[/TD]
[TD] [/TD]
[TD] [/TD]
[TD]350,000.89[/TD]
[TD][/TD]
[/TR]
[TR]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD]=-116,666.96*2[/TD]
[TD]($116,666.96/ month 2 of 3)[/TD]
[/TR]
[TR]
[TD] [/TD]
[TD] [/TD]
[TD][/TD]
[TD]=116,666.97[/TD]
[TD] [/TD]
[/TR]
</tbody>[/TABLE]
I want it to be [TABLE="width: 547"]
<tbody>[TR]
[TD]
=-116,666.96*3[/TD]
[TD]($116,666.96/ month 3 of 3) [/TD]
[/TR]
</tbody>[/TABLE]
Please advise or where I can find similar idea.
Thanks
I want to make an auto increment in my cell formula. The idea is every time I put a check mark , it will increase by 1.
For example:[TABLE="width: 547"]
<colgroup><col><col><col><col><col></colgroup><tbody>[TR]
[TD]
10/16-12/16[/TD]
[TD] [/TD]
[TD] [/TD]
[TD]350,000.89[/TD]
[TD][/TD]
[/TR]
[TR]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD]=-116,666.96*2[/TD]
[TD]($116,666.96/ month 2 of 3)[/TD]
[/TR]
[TR]
[TD] [/TD]
[TD] [/TD]
[TD][/TD]
[TD]=116,666.97[/TD]
[TD] [/TD]
[/TR]
</tbody>[/TABLE]
I want it to be [TABLE="width: 547"]
<tbody>[TR]
[TD]
=-116,666.96*3[/TD]
[TD]($116,666.96/ month 3 of 3) [/TD]
[/TR]
</tbody>[/TABLE]
Please advise or where I can find similar idea.
Thanks