Course Notes: Week #2 (Sept. 28-Oct. 2)
Course Notes: Week #2 (Sept. 28-Oct. 2) CSE 1111
Popular in Intro to Computer Problem Solving
verified elite notetaker
Popular in Computer Science and Engineering
verified elite notetaker
This 2 page Class Notes was uploaded by Megan Hageman on Thursday October 1, 2015. The Class Notes belongs to CSE 1111 at Ohio State University taught by Cindy Grimme in Summer 2015. Since its upload, it has received 31 views. For similar materials see Intro to Computer Problem Solving in Computer Science and Engineering at Ohio State University.
Reviews for Course Notes: Week #2 (Sept. 28-Oct. 2)
Report this Material
What is Karma?
Karma is the currency of StudySoup.
You can buy or earn more Karma at anytime and redeem it for class notes, study guides, flashcards, and more!
Date Created: 10/01/15
CSE 1111 Week #2 Course Notes (Sept. 28 -‐Oct. 2 ) Course Notes 1.8 The IF Function: evaluates similar to AND, OR, NOT functions but instead of just returning the answer TRUE or FALSE it performs another action based on if it is TRUE or FALSE -‐ Basically takes the process one step further -‐ IF(logical_test, value_if_true, value_if_false) Nested IFS: -‐ If there are more than just the TRUE or FALSE results -‐ Maybe there is another criteria within the TRUE or FALSE function EX: Does a person earn less than $1000? If this statement is TRUE then the company contribution the person must make is automatically $0. But, if the statement is FALSE, meaning the person makes more than $1000, you must then determine if this person makes under $2000. If that is TRUE, they do make less than $2000, then their contribution is 50%. If that statement is FALSE again then their contribution is 100%. -‐ In this example there is a second requirement after you determine the first statement is FALSE -‐ In the third argument you would have a nested IF function to account for this Lecture Notes (Sept. 29 ) th IFs and Nested IFs IF function: -‐ Must result in a Boolean function -‐ Can display other things besides just TRUE or FALSE IF(Logical_test, value_if_true, value_if_false) -‐ The third value is optional Ex: IF(E4>=300, “pass”, “fail”) The function can also return a specific number Ex: IF(E4<150, E4*1.1, E4) IFs with Boolean and arithmetic functions in the condition Ex: IF(AND(logical_test, logical_test2,…), “A”, FALSE) You can use a logic diagram/decision tree before designing a Nested-‐IF formula -‐ Second or third argument of an IF statement can be another IF statement (up to 64 levels of Nested IFs) *ORDER MATTERS -‐ Order matters with criteria that are not mutually exclusive Lecture (Oct. 1 ) -‐ In-‐Class Exercise #3
Are you sure you want to buy this material for
You're already Subscribed!
Looks like you've already subscribed to StudySoup, you won't need to purchase another subscription to get this material. To access this material simply click 'View Full Document'