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: 609
Experience:  I am an MIT graduate with a Master of Science degree from UC Berkeley.
76287196
Type Your Software Question Here...
Joel Kalman is online now

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

Resolved Question:

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.
Paul
Submitted: 3 years ago.
Category: Software
Expert:  Joel Kalman replied 3 years ago.

JoelK :

IF(AND(d6=Somerset

JoelK :

Sorry

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, Computer Specialist
Category: Software
Satisfied Customers: 609
Experience: I am an MIT graduate with a Master of Science degree from UC Berkeley.
Joel Kalman and 3 other Software Specialists are ready to help you
Expert:  Joel Kalman replied 3 years ago.
Paul,

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.

Joel

What Customers are Saying:

 
 
 
  • My Expert answered my question promptly and he resolved the issue totally. This is a great service. I am so glad I found it I will definitely use the service again if needed. One Happy Customer
< Previous | Next >
  • My Expert answered my question promptly and he resolved the issue totally. This is a great service. I am so glad I found it I will definitely use the service again if needed. One Happy Customer
  • Wonderful service, prompt, efficient, and accurate. Couldn't have asked for more. I cannot thank you enough for your help. Mary C.
  • This expert is wonderful. They truly know what they are talking about, and they actually care about you. They really helped put my nerves at ease. Thank you so much!!!! Alex
  • Thank you for all your help. It is nice to know that this service is here for people like myself, who need answers fast and are not sure who to consult. GP
  • I couldn't be more satisfied! This is the site I will always come to when I need a second opinion. Justin
  • Just let me say that this encounter has been entirely professional and most helpful. I liked that I could ask additional questions and get answered in a very short turn around. Esther
  • Wonderful service, prompt, efficient, and accurate. Couldn't have asked for more. I cannot thank you enough for your help. Mary C.
 
 
 

Meet The Experts:

 
 
 
  • Steve Herrod

    Steve Herrod

    Computer Support Specialist

    Satisfied Customers:

    160
    Familiar with a wide variety of software and experienced in user training/support
< Previous | Next >
  • http://ww2.justanswer.com/uploads/SP/spherrod/2012-6-6_174244_1000852.64x64.JPG Steve Herrod's Avatar

    Steve Herrod

    Computer Support Specialist

    Satisfied Customers:

    160
    Familiar with a wide variety of software and experienced in user training/support
  • http://ww2.justanswer.com/uploads/JE/jessmagz/2012-6-6_18129_jm.64x64.jpg Jess M.'s Avatar

    Jess M.

    Computer Support Specialist

    Satisfied Customers:

    116
    Computer Software Support specialist for more that 10 years
  • http://ww2.justanswer.com/uploads/SE/Seashore2011/2011-12-6_33418_111205223015.64x64.jpg Chris L.'s Avatar

    Chris L.

    Support Specialist

    Satisfied Customers:

    114
    Certified Software expert with over 10 years experience.
  • http://ww2.justanswer.com/uploads/FS/fszcze/2012-6-18_181848_500test.64x64.jpg Frederick S's Avatar

    Frederick S

    Computer Specialist

    Satisfied Customers:

    91
    Computer technician; founder of a home PC repair company.
  • http://ww2.justanswer.com/uploads/WA/wa94sound/2012-6-6_202633_iStock000007010121Small.64x64.jpg Bernie's Avatar

    Bernie

    Software Support

    Satisfied Customers:

    52
    6+ years experience, Microsoft MCDST/CompTia A+ Certified
  • http://ww2.justanswer.com/uploads/CH/chutz747/2011-11-6_14231_me.64x64.jpg The-PC-Guy's Avatar

    The-PC-Guy

    Software Engineer

    Satisfied Customers:

    38
    20 years experience providing remote computer support
  • http://ww2.justanswer.com/uploads/jnayes/2010-12-23_132454_japicbetter.jpg jnayes's Avatar

    jnayes

    Computer Support

    Satisfied Customers:

    37
    Network Administrator