Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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".

image text in transcribed
AutoSave OFF COMM 1503 Assignment 3 Home Insert Draw Page Layout Formulas Data Review View Tell me Calibri (Body) 11 A A ab Wrap Text v General Paste BIUV A E Merge & Center v $ ~ % " 00 .00 Clipboard Font Alignment Number 18 x v fx A B C D E F G H I K L M CAESAR SALAD WITH GRILLED CHICKEN Chicken Croutons Parmesan Lettuce Kale Total Serving Size (g) 140 14 28 17 67 296 Calories (kcal) 231 50 121 33 443 Fat (g) 5 3 CO 16 Saturated Fat (g) 1 5 6 Trans Fat (g) 8 Saturated Fat + Trans Fat (g) 1 5 6 9 Cholesterol (mg) 119 0 25 144 10 Sodium (mg) 104 90 428 booo 655 11 Carbohydrate (g) NOW LE 12 Fibre (g) 0 13 Sugar (g) 14 Protein (g) 43 11 57 15 16 17 18 19 20 21

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Exploring Economics

Authors: Robert L Sexton

5th Edition

978-1439040249, 1439040249

More Books

Students also viewed these Economics questions

Question

What does the start( ) method defined by Thread do?

Answered: 1 week ago