using 365
I have a drop down menu in cell B6. I want to populate cell E29 with an X based on a choice I make in B6 drop down.
Multiple choices from the B6 drop down list can give me an X in E29 and I have a formula working in E29 that gives me an X based on one of the choices.....how do I make E29 populate with an X if I chose a different choice in B6 drop down?
Here is my formula in E29 working with one choice: =IF($B$6="Cart 1 (hot)","X","") So this is saying leave E29 blank UNLESS I choose Cart 1 (hot) from B6 drop down...and if I do chose it, put an X in E29.
But I also need an X to show in E29 if I choose Cart 2 (hot) in B6 drop down.
How do I incorporate that cart 2 hot into the formula? I tried this but E29 populates as FALSE : =IF($B$6="Cart 1 (hot)",IF($B$6="Cart 2 (hot)","X",""))
Why is the formula not working???
I have a drop down menu in cell B6. I want to populate cell E29 with an X based on a choice I make in B6 drop down.
Multiple choices from the B6 drop down list can give me an X in E29 and I have a formula working in E29 that gives me an X based on one of the choices.....how do I make E29 populate with an X if I chose a different choice in B6 drop down?
Here is my formula in E29 working with one choice: =IF($B$6="Cart 1 (hot)","X","") So this is saying leave E29 blank UNLESS I choose Cart 1 (hot) from B6 drop down...and if I do chose it, put an X in E29.
But I also need an X to show in E29 if I choose Cart 2 (hot) in B6 drop down.
How do I incorporate that cart 2 hot into the formula? I tried this but E29 populates as FALSE : =IF($B$6="Cart 1 (hot)",IF($B$6="Cart 2 (hot)","X",""))
Why is the formula not working???