=IF(J1:J3,D10/2,"Please Check All Boxes")


I need help with the above formula. I have True and false check boxes in J1, J2 and J3. If all 3 check boxes are checked, I need it to do the D10/2 formula. For some reason, I cannot get all 3 to work..

Any ideas????