COMP 1010 Lecture 37: Lecture 37
17 May 2017
School
Department
Course
Professor
Document Summary
Lomoar cpsd| 987298: make function for other two, =if(f3 >= 80, a , b ) - greater than. = a, not = b: add the two together, =if(f3 < 70, c , if(f3 >= 80, a , b )) It is better to put the nested if in the false position rather than in the true position. Combines decision making with a calculation over a range. Will count or sum values only if those values satisfy a condition. =countif(b3:b13, <15 ) - will only count values in range that are less than 15. Sumif has a more advanced use as well, including 3 arguments: =sumif(b2:b13, <15 , f3:f13) - compares values in b3:b13 to see if they are less than 15, if true, adds values in f3:f13. Ranges can expand/contract as new rows/columns are added. If 2 rows are added between row 3 & 4, =sum(b3:b8) will accommodate those 2 new rows and become =sum(b3:b10)
