{[ promptMessage ]}

Bookmark it

{[ promptMessage ]}

EGR_102_Lab_02B_Excel_III

EGR_102_Lab_02B_Excel_III - Microsoft Excel III EGR102 Lab...

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

View Full Document Right Arrow Icon
Microsoft Excel ® III EGR102 - Lab 02B 1
Background image of page 1

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

View Full Document Right Arrow Icon
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
Background image of page 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
Background image of page 3

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

View Full Document Right Arrow Icon
IF Function Nested IF functions contain more IF statements in the value_if_true or value_if_false arguments
Background image of page 4
Image of page 5
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 Right Arrow Icon bookmark
Ask a homework question - tutors are online