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 Jess M. Your Own Question

Jess M.
Jess M., Computer Support Specialist
Category: Microsoft Office
Satisfied Customers: 6211
Experience:  Computer Software Specialist for more than 10 years
49766785
Type Your Microsoft Office Question Here...
Jess M. is online now
A new question is answered every 9 seconds

I am trying to create an IF formula thats says if cell J12

This answer was rated:

I am trying to create an IF formula that's says if cell J12 says damage or repair then insert a Y or N in k12. I have been working on this for hours and have gotten nowhere. Please help!

Jess M. :

Hi, welcome and thank you for your question. My name is XXXXX XXXXX I am glad to assist you today. Please let me know when you are ready for chat.

Customer:

I'm ready

Jess M. :

Thank you for joining chat.... What cell are you putting the IF formula so that I can test it here in my Excel?

Customer:

K12

Jess M. :

Ok, please give me a moment while I try a working for mula....

Customer:

OK. If you need more info just let me know. My question may be too vague

Jess M. :

Yeah, please give me a moment to create a working formula for you....

Jess M. :

When will K12 say Y? When will it show N?

Jess M. :

When J12 is damage, will k12 show y? and n if j12 is repair?

Customer:

It will show Y if the cell says damage or repair and N otherwise

Jess M. :

ok.... thank you for that clarification....

Jess M. :

Here is the formula that you need to use in K12:
=IF(OR(J12="damage",J12="repair"),"Y","N")

Jess M. :

Please copy that formula to your K12 and it shall work... This is a direct use of the OR boolean function.

Customer:

Am I allowed to try this before leaving chat?

Jess M. :

Yes please.....

Customer:

They all say N

Jess M. :

Please copy the formula correctly. It should work....I tried this in my Excel sheet as well

Jess M. :

don't miss the double quotation marks for damage, repair, y and n.

Jess M. :

Since they are text or characters, they need to be enclosed in double quotation marks.... (" ")

Jess M. :

I will send you my sample file for you to try it yourself....

Customer:

Writing is down. Please wait

Jess M. :

yes please...take your time:
=IF(OR(J12="damage",J12="repair"),"Y","N")

Customer:

Yes! It worked and thank you sooo much.

Jess M. :

You're always welcome.

Jess M. :

I am glad to be of help.....

Customer:

Thanks again. Have a great day!

Jess M. :

Please remember to rate my service if this helped. You can request me any time if you need assistance in the future...

Customer:

Will do.

Jess M. :

Thank you for using our service.

Best regards,
Jess

Jess M. and 3 other Microsoft Office Specialists are ready to help you