Microsoft Office Questions? Ask a IT Expert for Support ASAP
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.
Thank you for joining chat.... What cell are you putting the IF formula so that I can test it here in my Excel?
Ok, please give me a moment while I try a working for mula....
OK. If you need more info just let me know. My question may be too vague
Yeah, please give me a moment to create a working formula for you....
When will K12 say Y? When will it show N?
When J12 is damage, will k12 show y? and n if j12 is repair?
It will show Y if the cell says damage or repair and N otherwise
ok.... thank you for that clarification....
Here is the formula that you need to use in K12:=IF(OR(J12="damage",J12="repair"),"Y","N")
Please copy that formula to your K12 and it shall work... This is a direct use of the OR boolean function.
Am I allowed to try this before leaving chat?
They all say N
Please copy the formula correctly. It should work....I tried this in my Excel sheet as well
don't miss the double quotation marks for damage, repair, y and n.
Since they are text or characters, they need to be enclosed in double quotation marks.... (" ")
I will send you my sample file for you to try it yourself....
Writing is down. Please wait
yes please...take your time:=IF(OR(J12="damage",J12="repair"),"Y","N")
Yes! It worked and thank you sooo much.
You're always welcome.
I am glad to be of help.....
Thanks again. Have a great day!
Please remember to rate my service if this helped. You can request me any time if you need assistance in the future...
Thank you for using our service.Best regards,Jess