BUS-K 201 Lecture 6: BUS-K201 Excel Lab Class 4-6
Document Summary
The and function allows multiple logical criterias to be tested. All logical tests have to met but to execute the true value. The or function allows multiple logical criterias to be tested. =if(logical test, value_if_true, if(logical test, value_if_true, if(logical test, The if statements after the first one will be placed as the value_if_false. You can put as many if statements as possible inside other if statements. How to count the number of filled cells. This will return the number of filled cells with the specified range. Takes the number of the specified criteria and divides it with the total amount of numbers. The if statement has criterias that have to be met. The and statement within the if function means both criterias have to be met for. The or statement within the and function means one of the two (or both) the function to be true, otherwise false criterias have to be true to make the if function true.