• Go back-and-forth until satisfied
Techie_Ben, Software Engineer
Category: Software
Satisfied Customers: 3423
Experience:  15+ years experience in troubleshooting
8287049
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!