Checkbox TRUE converts another cell number to "0"
Checkbox TRUE converts another cell number H2 "TOTAL" to number "0"
Checkbox TRUE converts another cell number H2 "TOTAL" to number "0"
Hi Organizing,
Since there is no way to change the data entered into a cell, I suspect what you want is to do this.
You will have to set up an additional cell to repond to your checkbox.
I2=IF(A2,0,H2)
Is this what you are looking for?
quinn
Hi Organizing,
Since there is no way to change the data entered into a cell, I suspect what you want is to do this.
You will have to set up an additional cell to repond to your checkbox.
I2=IF(A2,0,H2)
Is this what you are looking for?
quinn
You question is not clear. Can you try to describe your question again another way?
When I use the checkbox (A2) and check it (TRUE), it makes the amount in H2 ($5.00) turn to zero (0).
Thanks in advance.
That's it. Workaround and create a different column. High 5!
Cheers,
O
Back at ya.
q
Checkbox TRUE converts another cell number to "0"