Looks like no one’s replied in a while. To start the conversation again, simply ask a new question.

Checkbox TRUE converts another cell number to "0"

Checkbox TRUE converts another cell number H2 "TOTAL" to number "0"


Posted on Sep 24, 2019 1:47 PM

Reply
Question marked as Best reply

Posted on Sep 24, 2019 4:03 PM

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

5 replies

Checkbox TRUE converts another cell number to "0"

Welcome to Apple Support Community
A forum where Apple customers help each other with their products. Get started with your Apple ID.