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.
  • Go back-and-forth until satisfied
    Rate the answer you receive.
By continuing to use this site you consent to the use of cookies on your device as described in our cookie policy unless you have disabled them.
Ask Robert H Your Own Question
Robert H
Robert H, Computer Hardware Engineer
Category: Programming
Satisfied Customers: 5396
Experience:  Computer and IT support Engineer
106466437
Type Your Programming Question Here...
Robert H is online now

=IF(L4="W","0"),IF(L4="L",(O4-P4<7=,"1")(04-P4>7=,"0") need

Customer Question

=IF(L4="W","0"),IF(L4="L",(O4-P4<7=,"1")(04-P4>7=,"0") need to show a 0 if a win and need two for a L one being under 7 is a 1 and over a 7 is a 0
JA: Is there a specific language you're coding in?
Customer: just excel
JA: When did you last update Excel?
Customer: unsure as my laptop does automatic updates
JA: What have you tried so far with your Excel?
Customer: just that first line i sent you, its the only thing i didnt consider until i was half way through adding teams and results
JA: Anything else you want the Software Expert to know before I connect you?
Customer: thats it really, just need a formula to calculate if cell is a W=0 L<7=1 L>7=0
Submitted: 2 years ago.
Category: Programming
Robert H
Expert:  Robert H replied 2 years ago.

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.

Ask Your Own Programming Question
Customer: replied 2 years ago.
hi
Expert:  Robert H replied 2 years ago.

Let me review and get a formula for you!

Ask Your Own Programming Question
Expert:  Robert H replied 2 years ago.

are you able to attach the spreadsheet? Sometimes it's easier if I can see the actual data :)

Ask Your Own Programming Question
Expert:  Robert H replied 2 years ago.

I got it

Ask Your Own Programming Question
Expert:  Robert H replied 2 years ago.

=IF(AND(L4="L",O4<7),1,0)

Ask Your Own Programming Question
Expert:  Robert H replied 2 years ago.

Simplifying it - If it's an L AND less than 7 put a "1". Anything else is a "0". :D

Ask Your Own Programming Question
Expert:  Robert H replied 2 years ago.

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!

Ask Your Own Programming Question
Expert:  Robert H replied 2 years ago.

Please let me know if there's any additional assistance I can provide. I'm happy to help!

Ask Your Own Programming Question