Ask Your Question

Calc: If/Then with Checkbox [closed]

asked 2020-07-10 05:40:09 +0100

Russ G gravatar image

updated 2020-08-09 00:06:41 +0100

Alex Kemp gravatar image

Is there a way for me to perform an if/then in Calc (v5) based on whether or not a checkbox is checked?

I want calc to run one calculation if the box is checked and another if it is not. I know checkboxes can be inserted but I don't know how to use them or if they can be used as I describe.

If it's easy to do I'd like to try it but if this is complicated please do not feel the need to explain the process. I casn probably find another way to handle the situation.


edit retag flag offensive reopen merge delete

Closed for the following reason the question is answered, right answer was accepted by Alex Kemp
close date 2020-08-09 00:07:14.150267

1 Answer

Sort by » oldest newest most voted

answered 2020-07-10 07:34:25 +0100

JohnSUN gravatar image

Go to tab Data in control property


edit flag offensive delete link more

Question Tools

1 follower


Asked: 2020-07-10 05:40:09 +0100

Seen: 50 times

Last updated: Jul 10