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.
Ask Techie_Ben Your Own Question
Techie_Ben
Techie_Ben, Software Engineer
Category: Software
Satisfied Customers: 3423
Experience:  15+ years experience in troubleshooting
8287049
Type Your Software Question Here...
Techie_Ben is online now

How is this formula updated so that if these conditions

Customer Question

How is this formula updated so that if these conditions aren't met result is 0 not False?=IF(E17>=24,IF(F17>=700,70),IF(E17>=20,IF(F17>=600,60),IF(E17>=16,IF(F17>=500,50),IF(E17>=12,IF(F17>=400,40)))))
Submitted: 14 days ago.
Category: Software
Expert:  Techie_Ben replied 14 days ago.
Hello, and thank you for the question. Sorry to hear about the issue you’re having with your formula. I know it can be frustrating, but please give me a moment to review the details of your question and I will get back to you shortly. Thanks again!
Expert:  Techie_Ben replied 14 days ago.
Can you please attach an example sheet where you are seeing the problem? I’ll be happy to review and assist as best I can. I look forward to your reply. Thanks again!
Customer: replied 14 days ago.
0 value should if E17 is 11 or less or F17 599 or less and no False values.
Customer: replied 14 days ago.
Highest values is 24 and 70 and anything above that should return 70
Expert:  Techie_Ben replied 14 days ago.
Can you please attach an example sheet where you are seeing the problem? I’ll be happy to review and assist as best I can. I look forward to your reply. Thanks again!
Expert:  Techie_Ben replied 14 days ago.

The first value in the formula is the value to return, followed by the value to return if the condition evaluated false.

Please let me know if you have any questions. Thanks again!