I'm having trouble removing the "FALSE" statement in Block G7. My goal is to have Block G7 populate a value based on whether the Check Box is clicked in cells B7:E7 . The boxes are not dependent (only one should be checked at a time) but when no boxes are checked, I would like the FALSE statement to not appear.
This is the formula and it works in that if a cell is checked, it populates the correct numerical value assigned to Check Box. Thanks for the guidance!
=IF(B7,5,IF(C7,3,(IF(D7,0,IF(E7,"N/A")))))
This is the formula and it works in that if a cell is checked, it populates the correct numerical value assigned to Check Box. Thanks for the guidance!
=IF(B7,5,IF(C7,3,(IF(D7,0,IF(E7,"N/A")))))