If Statement with check box and list

LGNgirl

New Member
Joined
Nov 19, 2010
Messages
25
Im using a checkbox using an if statement that looks like:

=IF(B2=TRUE,E2:E4)

Now E2 is apple
E3 is pear
E4 is orange

What I want to happen is that when I check the check box I want E2,E3,and E4 to show up like:

apple
pear
orange

It is only showing E2 (apple)

I tried =IF(B2=TRUE,E2&E3&E4) and got closer but it is only appearing as:

applepearorange

How do I get it to appear in columns than one row?

Thankyou for your help
 

Excel Facts

Remove leading & trailing spaces
Save as CSV to remove all leading and trailing spaces. It is faster than using TRIM().

Forum statistics

Threads
1,224,525
Messages
6,179,317
Members
452,905
Latest member
deadwings

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
Back
Top