I have a check box on my sheet that when checked (true), the formula returns zero.
When left unchecked (false), the formula returns intended results.
Formula example looks like this: IF A1,0,b1xc1). (IF checkboxcell,0,cellxcell).
I would like to track the duration of time that has passed from that row with the checkbox.
Let me try to explain, when the category within the “checked row” has not been listed again for 30 days, there would be a color change or a cell with some text that will let me know. If it has been listed, I would see that as well.
Kind of confusing, get what I mean?
Any help would be greatly appreciated!
I use this sheet to journal stock trading.
If a stock is sold at a loss and bought back within 31 days of sale there are tax implications.
The checkbox allows a calculation for tax requirements. When checked, which would only be on a loss, the outcome would be zero.
When left unchecked it calculates tax required and lists that calc in a cell.