by FJCC » Wed Jan 16, 2019 4:42 am
Try
- Code: Select all Expand viewCollapse view
=IF(C2;B2;0)
Things to note:
1. Use a semicolon between the parts of a function.
2. Using C2 = "TRUE" as the first part of the IF() does not work because the TRUE or FALSE value sent by the checkbox is a number, not the text "TRUE" or "FALSE". The cell format is set to display the number 1 as TRUE and the number 0 as FALSE. You can see this by changing the cell format of C2 with the menu Format -> Cells. If you set the format to display integers, clicking the checkbox will toggle the cell between 0 and 1.
3. In OpenOffice, FALSE is Zero and TRUE is Not Zero. So my formula is equivalent to
- Code: Select all Expand viewCollapse view
=IF(C2 <> 0; B2;0)
Windows 10 and Linux Mint, since 2017
If your question is answered, please go to your first post, select the Edit button, and add [Solved] to the beginning of the title.