How can I use if with a check box to perform a formula?
I would like to have a column with a cheek box which, if ticked, performs a formula in the next column. Would anyone know how to do this?
Is this what you mean?
B1=IF(A1=TRUE, C1+D1, "")
this is shorthand for select cell B1, then type (or copy and paste from here) he formula:
=IF(A1=TRUE, C1+D1, "")
Check box not checked:
Check box checked:
when the checkbox is checked cell B1 will contain the sum of cells C1 and D1 otherwise cell B1 is empty