Question
1. (15 points) In the 'IF Function' sheet: assume that the total for Saturated Fat + Trans Fat should not exceed 3 g, the total
1.(15 points) In the 'IF Function' sheet: assume that the total for Saturated Fat + Trans Fat should not exceed 3 g, the total for Sodium should not exceed 500 mg, and that of Protein should be at least 40 g. Use the IF Function to type 'Yes!' in front of the total if the condition is met, and 'No' if it is not met.
Hint 1: Add a new column (between column Kale and Total) and show the output on that column.
Hint 2: In total, you need to insert 3 IF functions, i.e., one for Saturated Fat + Trans Fat, one for Sodium, and one for Protein.
My question is what statements/constraints should i put into the IF function to receive "Yes" or "NO".
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started