Forum Discussion
Re: Checkboxes not automatically updating using COUNTIF
Maybe I'm not seeing the bigger picture, but why not simplify the formula to be:
=AND(A2,A3)
1 Reply
I was assuming they want the IF and =2 for specific reasons but that really isn't the problem. The problem here is that online version of Excel is not behaving with respect to these checkboxes. Here are 2 checkboxes and 2 formulas looking them. In 1 is the simple formula and in the other I added a volatile function. Notice how after I clicked the 2 boxes the original still says FALSE but the other correctly updated to TRUE
again, this is happening on the online version NOT the desktop version
