Class Notes (838,549)
United States (325,481)
Boston College (3,571)
CSCI 1031 (14)
James Gips (14)
Lecture

October 2

2 Pages
96 Views
Unlock Document

Department
Computer Science
Course
CSCI 1031
Professor
James Gips
Semester
Fall

Description
October 2, 2013 Use the IF function to apply subjective formulas Ex. You have a policy that for orders over $100, the shipping is free; for orders under $100,  shipping is $5 =IF(value in question>subjective value, value if true, value if false) =IF(C22>100, 0,5) Can’t do S, <>, <=, >= Condition is evaluated to be true or false Logical value, Boolean value, True/False Cecage Boole For orders under $100 shipping is 5%; for orders between $100 and $2,000 shipping is $10; for  orders over $2,000 shipping is free; for orders over $2,000,000 you get a free Mercedes Format: =IF(C22<100, 5%*C22, IF(C22<=2000, 10, IF(C22<=2000000, “Free”, “You get a free  Mercedes”))) Nested IF function An IF function within
More Less

Related notes for CSCI 1031

Log In


OR

Join OneClass

Access over 10 million pages of study
documents for 1.3 million courses.

Sign up

Join to view


OR

By registering, I agree to the Terms and Privacy Policies
Already have an account?
Just a few more details

So we can recommend you notes for your school.

Reset Password

Please enter below the email address you registered with and we will send you a link to reset your password.

Add your courses

Get notes from the top students in your class.


Submit