At Fixya.com, our trusted experts are meticulously vetted and possess extensive experience in their respective fields. Backed by a community of knowledgeable professionals, our platform ensures that the solutions provided are thoroughly researched and validated.
You don't mention the boolean relationship between these tests (e.g. AND or OR), so here is both cases. If all three have to be true for the result to be High, then use =IF(AND(A9 >=70, B9 >= 200, C9 = "HIGH"),"High","Low") However, if A9 is greater or equal to 70 OR B9 is greater than or equal to 200 OR if C9 = High, then use this one: =IF(OR(A9 >=70, B9 >= 200, C9 = "HIGH"),"High","Low"). You could also do it with nested IFs, but this is cleaner and easier.
Follow-up. Forgot you wanted High or Regular Sodium, so just change "Low" to "Regular" in the formula.Follow-up. Forgot you wanted High or Regular Sodium, so just change "Low" to "Regular" in the formula.
You can't post conmments that contain an email address.
- If you need clarification, ask it in the comment box above.
- Better answers use proper spelling and grammar.
- Provide details, support with references or personal experience.
Tell us some more! Your answer needs to include more details to help people.You can't post answers that contain an email address.Please enter a valid email address.The email address entered is already associated to an account.Login to postPlease use English characters only.
Tip: The max point reward for answering a question is 15.
×