• Go back-and-forth until satisfied
Kat, Expert
Category: Software
Satisfied Customers: 171
Experience:  Expert
110517830
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.
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"))))