Title: Pulling data from one selection based on two check boxes (form control)
Tags: excel;checkbox
Question: Cell F17 is to be set at zero, if no data is found in the three criteria.
Either Cell E21, G25, or G28 will have the required data.
I need to know how to make F17 (Sheet Count) pull the data if one of the two check boxes is checked (G23 or G26) (one or the other, not both) whichever is checked is where the data will pull from. If neither is checked then the data is equal to E11/E21.
Currently I have G23 and E21 working based on if G23 is checked by:
E21 =IF(G23=TRUE,0,4)
I can't get passed making two check boxes work with another cell with criteria if the other two are not checked.


Here is another answer: I am a bit confused, but please try (in F17?):
=IF(AND(G23=TRUE,G26=FALSE),G25,IF(AND(G23=FALSE,G26=TRUE),G28,E11/E21))
Assumes your Check Boxes are linked to G23 and G26.

{'source': 'StackExchangeDataset', 'subset': 'stackoverflow.com', 'metadata': {'AnswerCount': 1, 'CommentCount': 0, 'ContentLicense': 'CC BY-SA 3.0', 'CreationDate': '2015:00:10/07/15', 'FavoriteCount': None, 'PostTypeId': 1, 'Tags': '<excel><checkbox>', 'Title': 'Pulling data from one selection based on two check boxes (form control)', 'ViewCount': 65, 'id': 33004250, 'user_AboutMe': None, 'user_AccountId': 7083029.0, 'user_DisplayName': 'Jeremiah Fritz', 'user_Reputation': 11.0, 'user_Views': 7.0, 'user_id': 5420732.0}}