Programming
Programming Questions? Ask a Programmer for Answers ASAP
Hello and welcome to JustAnswer, an independent Question & Answer web portal. My name is ***** ***** I am happy to be assisting you today.
Please note: If you get an offer for premium service please hold off on that for now. That offer is automatically generated by this website, not by me. I can offer you whatever is needed to solve your problem.
Let me review and get a formula for you!
are you able to attach the spreadsheet? Sometimes it's easier if I can see the actual data :)
I got it
=IF(AND(L4="L",O4<7),1,0)
Simplifying it - If it's an L AND less than 7 put a "1". Anything else is a "0". :D
If you need any further assistance, I am happy to help.
My goal is to provide excellent service to you! Please be sure to provide a rating for me -
(Scroll the screen up and on the right top corner. Select the stars and click on Submit!).
That will close out the question and prevent you from further automated notifications, and any additional charges. Thank you!
Please let me know if there's any additional assistance I can provide. I'm happy to help!