LauraEdson10
New Member
- Joined
- Apr 10, 2018
- Messages
- 21
- Office Version
- 365
- Platform
- Windows
I have two pages in an Excel spreadsheet. The first page contains 3 ActiveX checkboxes. Behind the checkboxes, in the cells, if the box is ticked, it will enter "TRUE" and if unticked, "FALSE". There are three of these boxes on this sheet.
On the next page, I'm wanting to write a formula to say IF box 1 = "TRUE" then enter text "BOX 1" OR IF box 2 = "TRUE" then enter text "BOX 2" OR IF box 3 = "TRUE" then enter text "BOX 3". There will only be one box ticked at a time - there cannot be two boxes ticked or even three boxes ticked.
It's basically combining the result of three checkboxes but entering text for each result into the one cell?
I'm struggling to find a formula that fits this but it seems rather easy! Thanks
On the next page, I'm wanting to write a formula to say IF box 1 = "TRUE" then enter text "BOX 1" OR IF box 2 = "TRUE" then enter text "BOX 2" OR IF box 3 = "TRUE" then enter text "BOX 3". There will only be one box ticked at a time - there cannot be two boxes ticked or even three boxes ticked.
It's basically combining the result of three checkboxes but entering text for each result into the one cell?
I'm struggling to find a formula that fits this but it seems rather easy! Thanks
Last edited: