COMM 205 Lecture Notes - Lecture 2: Lookup Table, Ampersand
Document Summary
Logical functions are functions that are used to test for specific conditions. (if,countif,sumif) The syntax for the if function is: =if(logical_test, [value_if_true], [value_if_false]). (use quotation when referring to text but don"t use around cell references, # values or formulas) Nested if- want to begin by evaluating the condition that doesn"t branch out=if(a2>=55, cr , if(a2>=50, d , f )) =max(number1, [number2], ). (same for min and sum) And function is used to evaluate if all arguments/logicals are true or false. Logical1 is required; logical 2, are optional. Or function is used to evaluate if at least one of arguments/logicals are true or false. Countifs count values in a specific range that meet certain criteria. Important: you need quotation marks to enclose numbers within countifs criteria(diff from if fcn) Sumifs function adds values in a specified range or multiple ranges that meet specified criteria. At least 1 criterion is needed, but up to 127 criteria can be tested.