Hey!

So I created a new table database today which is supposed to eventually become a pretty complex budget overview.

Here is to my problem:

In column 1 of the table I note down numbers, the second column shows a checkbox and the third column will be a formula.

If the checkbox in column 2 is checked, I want the formula in column 3 to return the exact same number that I noted down in column 1.

If the checkbox in column 2 is not checked, I want the formula in column 3 to return only a blank space.

So, I am pretty sure there must be some if-statement to achieve what I have in mind and I already know how to individually indicate the status of the checkbox or how to return the number by using a formula.

But I just can't happen to find a way to combine both so that the third column only shows a number if the second column shows a ticked checkbox.

If there is anyone who might have an idea how to get this problem fixed, I would deeply appreciate some help!

Thank you all in advance! :)