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)
    – JohnSUN
    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
    – JohnSUN
    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
    – JohnSUN
    Sep 22, 2022 at 18:21

1 Answer 1


I hope this helps to understand the sequence of actions to solve your problem:

Set numbers to checkbox value

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge that you have read and understand our privacy policy and code of conduct.

Not the answer you're looking for? Browse other questions tagged or ask your own question.