Possible IF OR Excel Formula

LauraEdson10

New Member
Joined
Apr 10, 2018
Messages
21
Office Version
  1. 365
Platform
  1. 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
 
Last edited:

Some videos you may like

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
Joined
Aug 4, 2017
Messages
1,055
Office Version
  1. 2016
Platform
  1. Windows
=IF(box 1,"BOX 1",IF(box 2,"BOX 2",IF(box 3,"BOX 3",""))) replace box 1 etc. with celaddresses.
 
Solution

Watch MrExcel Video

Forum statistics

Threads
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.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

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

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

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
Top