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 Kat Your Own Question
Kat
Kat, Expert
Category: Software
Satisfied Customers: 171
Experience:  Expert
110517830
Type Your Software Question Here...
Kat is online now

I would like to create the following formula If E17 is

Customer Question

I would like to create the following formulaIf E17 is minimum of 12 and F17 is minimum of 400 then 40. If E17 is minimum of 16 and F17 is minimum of 500 then 50
If E17 is minimum of 20 and F17 is minimum of 600 then 60
If E17 is minimum of 24 and F17 is minimum of 700 then 70
Submitted: 10 days ago.
Category: Software
Expert:  Kat replied 10 days ago.

Welcome to JA, sorry to hear your having issues creating a logical statement \ formula, what spreadsheet are you looking to use this formula in (Excel, Sheets, Numbers?

Customer: replied 10 days ago.
Google sheets
Expert:  Kat replied 10 days ago.

Ok so the easiest way to do this would be to use a nested IF statement so it would use something like:

=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)))))

Have a good evening do let me know if you need anything clarified.

Customer: replied 9 days ago.
Thank you! Currently if result is below the range result is False. How to update it so that it's N/A?
Customer: replied 9 days ago.
Is there a easy way to do this?
Expert:  Kat replied 8 days ago.

The formula below will return N/A if the logic statement can't match anything

=IF(E17>=24,IF(F17>=700,70,"N/A"),IF(E17>=20,IF(F17>=600,60,"N/A"),IF(E17>=16,IF(F17>=500,50,"N/A"),IF(E17>=12,IF(F17>=400,40,"N/A"),"N/A"))))