I have a spreadsheet with TRUE/FALSE values generated from a user form. The userform populates cells B4 through B8 with true/false values based on whether a radio button is selected on the userform.
I now need to identify a condition where if B6 is true and B4, B5, B7, B8 are false. If this condition is met, put a 1 in Cell H11. However, if any of the values B4, B5, B7, B8 are true, then i need the value of H11 to be a 2.
I thought the answer would be a simple nested IF/AND statement, but i can only get the first condition working correctly.
Any help would be appreciated.
Bookmarks