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

School
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
Me

OR

Join OneClass

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

Join to view

OR

By registering, I agree to the Terms and Privacy Policies
Just a few more details

So we can recommend you notes for your school.