How JustAnswer Works:
  • Ask an Expert
    Experts are full of valuable knowledge and are ready to help with any question. Credentials confirmed by a Fortune 500 verification firm.
  • Get a Professional Answer
    Via email, text message, or notification as you wait on our site. Ask follow up questions if you need to.
  • 100% Satisfaction Guarantee
    Rate the answer you receive.
Ask Joel Kalman Your Own Question
Joel Kalman
Joel Kalman, Computer Specialist
Category: Software
Satisfied Customers: 937
Experience:  I am an MIT graduate with a Master of Science degree in Electrical Engineering from UC Berkeley.
Type Your Software Question Here...
Joel Kalman is online now

I am using the following formula =IF(AND(D6="Somerset T"),C6,"") I

This answer was rated:

I am using the following formula
=IF(AND(D6="Somerset T"),C6,"")
I wish to include additional choices within cell D6 but I need help to add multiple choices to the formula.

I have four descriptions which could be in D6, the descriptions are chosen from a drop down list.

Any help would be appreciated.

JoelK :


JoelK :


JoelK :

Hello. Thank you for your question. I appreciate the opportunity to be of service.

This formula will work for two choices:
IF(AND(OR(D6="Somerset T"),D6="Something Else"),C6,"")

JoelK :

If you are satisfied with my answer, please rate my services. A positive rating allows me to be compensated for providing information and advice here.

Joel Kalman and 3 other Software Specialists are ready to help you

I am grateful for the opportunity to be of service. I am glad that I was able to assist you in finding the best solution to your technical problem.

If you have any software problems in the future where I can be of assistance, please return to Just Answer and ask for me by name. Thank you.