# Using a checkbox to show data in other cells

Is there a way that when you put a check in a checkbox it will show number values in two separate cells? I'm creating an assessment that will have 20 questions, each question will have 2 or 3 choices (checkbox). Each choice (checkbox) will have 2 numbers that are in two separate columns. Those two columns will be totaled at the bottom of the assessment in their respective columns.

• Welcome! Yes, it's easy - write the formula `=<cell with checkbox>*<desired number>` (for example, `=B3*17`). If the checkbox is disabled, the cell will have 0, if enabled, the cell will contain the desired number. This can be done for two or three or more cells - they will all respond to the same checkbox. If a disabled checkbox needs a value other than 0, use the IF() function in the formula `=IF(B3,17,-22)` Sep 21, 2022 at 4:53
• Where do I put the formula? I have some experience with excel and Google sheets, but am very rusty. For example on my excel, A108 has the checkbox and I want the checkbox linked to cells H108 and I108. When checked, I want H108 to show 6 and I108 to show 7. Thank you for your help
– John
Sep 21, 2022 at 17:14
• Put to cell H108 `=A108*6` and `=A108*7` to cell I108 Sep 21, 2022 at 17:35
• I've tried that, but it is not working. When I put =A108*6 in cell H108 and hit enter, it puts a 0 in the cell. If I link the checkbox to H108 (\$H\$108), it puts a TRUE or FALSE as expected. I'm trying to get TRUE = 6 and FALSE = 0. I appreciate your help and patience.
– John
Sep 22, 2022 at 17:17
• That's right - the formula will show 0 while the checkbox is cleared and will show 6 when you check the checkbox Sep 22, 2022 at 18:21