Help with checkboxes

Question

Level 1

108 points

Help with checkboxes

Hello.

I have two columns with checkboxes, one is "Hold" the other is "Full", and then a third column with a number value.

If "Hold" is checked, the amount of "5" gets returned to the third column, if "Full" is checked, "10" gets returned.

I want to set it up so that another value gets returned (Like "FIX IT!!") if both checkboxes are checked. Nothing I have tried works. The formula that is in there now is:

IF(B2,5(IF (C2,10,0))

This works a little bit, but doesn't account for both B2 AND C2 being checked.

Any thoughts?

Posted on Oct 10, 2022 12:47 PM

Reply

Answer 1

Barry

Level 9

60,011 points

Oct 10, 2022 1:06 PM in response to JeremyG

Try this:

IFS(AND(B2,"FIX IT!"),10,B2,5,C2,10,true,"")

IFS checks the first argument (the 'condition') of each pair. IF true, it returns the second part ('result').

If that one is FALSE, IFS moves on to the next condition-result pair.

The last pair (true, "") MUST be a condition that will always be true and the result you want if none of the specified conditions is true.

Regards,

Barry

Reply

Answer 2

Barry

Level 9

60,011 points

Oct 10, 2022 7:06 PM in response to JeremyG

You're welcome.

Apologies for the error in the supplied formula. In a bit of a rush at the time of posting and didn't get back to check it. Glad to see you were able to read in what was missing.

Regards,

Barry

Reply

Answer 3

JeremyG Author

Level 1

108 points

Oct 10, 2022 1:21 PM in response to Barry

Fantastic. Had to modify a little bit for syntax.

IFS(AND(B2,C2),"FIX IT!",B2,5,C2,10,true,"0")

Many many thanks!

Reply

Help with checkboxes

Similar questions