I'm new to coding even more so on excel or google sheet. I'm currently trying to make a simple Combination and Permutation calculator based on a true or false statement in a tickbox, if true then it will calculate the combination of n and r. If false then it will calculate the permutation of n and r.

Here's a little demonstration of what I'm trying to achieve:

enter image description here

So, I would like to make an "if statement" that checks the true or false statement in C5, then if it's true, simply do "=COMBIN(B3, D3)" and if it's false, then do "=PERMUT(B3, D3)". Then print the result to C10.


1 Answer 1


The checkbox in cell C5 will be true when the box is ticked, and false when unticked, so you can just use this simple formula in cell C10:

=if( C5, combin(B3, D3), permut(B3, D3) )

  • thanks! That makes it clearer Aug 11, 2021 at 16:26

Your Answer

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

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