I would like to create the following formula If E17 is

We use cookies to improve your experience. By continuing to use this site you consent to the use of cookies as described in our cookie policy, unless you have disabled them.

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 Kat Your Own Question

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

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?