How can I change the value of a cell when a checkbox is ticked to show text instead of the number.
This is what I’m trying to achieve.
A1 = 9 but when checkbox in B1 is checked I want it to change A1 to “PAID”
iPhone 14 Pro, iOS 17
The literal answer to your question is to do something like this:
In A1:
=IF(B1,"Paid",9)
However, without more details on what you are trying to do I'm not sure how practical that is going to be.
SG
SG
The literal answer to your question is to do something like this:
In A1:
=IF(B1,"Paid",9)
However, without more details on what you are trying to do I'm not sure how practical that is going to be.
SG
SG
Numbers, checkbox change value of cell to “PAID”
