• 100% Satisfaction Guarantee
Jess M., Computer Support Specialist
Category: Microsoft Office
Satisfied Customers: 6960
Experience:  Computer Software Specialist for more than 10 years
49766785
Type Your Microsoft Office Question Here...
Jess M. is online now

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

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:

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. :

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:

Jess M. :

=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