# Possible IF OR Excel Formula

#### LauraEdson10

##### New Member
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

Last edited:

### Excel Facts

Highlight Duplicates
Home, Conditional Formatting, Highlight Cells, Duplicate records, OK to add pink formatting to any duplicates in selected range.

#### mart37

##### Well-known Member
=IF(box 1,"BOX 1",IF(box 2,"BOX 2",IF(box 3,"BOX 3",""))) replace box 1 etc. with celaddresses.

#### LauraEdson10

##### New Member
Perfect, thank you

Replies
3
Views
92
Replies
1
Views
221
Replies
1
Views
261
Replies
41
Views
552
Replies
1
Views
261

1,127,352
Messages
5,624,173
Members
416,017
Latest member
moritz210

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back