{[ promptMessage ]}

Bookmark it

{[ promptMessage ]}

EGR_102_Lab_02B_Excel_III

# EGR_102_Lab_02B_Excel_III - Microsoft Excel III EGR102 Lab...

This preview shows pages 1–5. Sign up to view the full content.

Microsoft Excel ® III EGR102 - Lab 02B 1

This preview has intentionally blurred sections. Sign up to view the full version.

View Full Document
IF Function Useful to assign different values to a cell based on a logical test General form = IF (logical_test, value_if_true, value_if_false) More examples: = IF (C34*\$W\$3 = K7, \$K\$6, L33-5) = IF (MIN(K8:L12) > 75, 1, 0) = IF (B1 <> 0, “No”, “Yes”) = IF (D19 = "taxable", C19*1.11, C19) = IF (AND(C12>0,C12<100), C12, 0) = IF (OR(G5<0,G6<0), “Wrong”, “Right”) EGR102 - Lab 02B 2
EGR102 - Lab 02B 3 IF with AND/OR Logical functions: Combine two or more comparison operators AND(), OR() AND requires all conditions in a set to be satisfied in order to be true = IF (AND(K7<10,K7>5), “true”, “false”) K7 must be less than 10 AND more than 5 in order to be true OR only requires one condition in the set to be satisfied to be true = IF (OR(K8<5,K8>10) , 1, 0) K8 must be less than 5 OR more than 10 in order to be true

This preview has intentionally blurred sections. Sign up to view the full version.

View Full Document
IF Function Nested IF functions contain more IF statements in the value_if_true or value_if_false arguments
This is the end of the preview. Sign up to access the rest of the document.

{[ snackBarMessage ]}

### Page1 / 12

EGR_102_Lab_02B_Excel_III - Microsoft Excel III EGR102 Lab...

This preview shows document pages 1 - 5. Sign up to view the full document.

View Full Document
Ask a homework question - tutors are online