A medical center Why not? must pay close attention to several health factors to

Question

A medical center Why not? must pay close attention to several health factors to determine what type of meals patients should receive The factors to consider include the patient's age, weight, blood pressure, and cholesterol Patients should level. receive low sodium meals iftheir blood pressure is high and if they meet at least one ofthe fol- lowing conditions: their age is at least 70 or their weight least 200 Patients should receive low cholesterol meals if their cholesterol level is high if they meet one of the following conditions: their age at least 70, their weight is at least 200 is or their blood pressure high. Patients may is also have low sodium and low cholesterol meals if they satisy the conditions for both the low sodium meal and the low cholesterol meal. If the

Explanation / Answer

=IF(AND(D2="HIgh",OR(B2>=70,C2>=200),"Low Sodium Meal", IF(AND(E2="HIgh",OR(B2>=70,C2>=200),"Low Cholestrol Meal" ,"Low Sodium/Low Cholestrol Meal")))

In the above formula we use logical function AND or OR along with the IF statement.

Related Questions

Navigate

• Browse (All)
• Browse A
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.