EGR_102_Lab_02B_Excel_III

EGR_102_Lab_02B_Excel_III - Microsoft Excel III EGR102 -...

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 DocumentRight 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 DocumentRight 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.

This note was uploaded on 04/02/2012 for the course EGR 100 taught by Professor Hinds during the Fall '08 term at Michigan State University.

Page1 / 12

EGR_102_Lab_02B_Excel_III - Microsoft Excel III EGR102 -...

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

View Full Document Right Arrow Icon
Ask a homework question - tutors are online