I suggest that you try my formula above. It turns out in Quickbase you don�t actually need to make an
IF statement when the result is going to be true or false. You can just make a statement and if the statement evaluates to true then the checkbox will get checked.
I am in the car right now so it�s a little hard to type but if I get a chance I will write out a longer formula that will make more sense to you. But meanwhile why don�t you just try a new field with my formula and see if it works.