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
=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