MIS-Excel If Funtions

MIS-Excel If Funtions - FALSE TRUE ANSWER M IS -If Function...

Info iconThis preview shows page 1. Sign up to view the full content.

View Full Document Right Arrow Icon
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: FALSE TRUE ANSWER M IS -If Function Notes: How they work: I.E = IF (COND1, IF (COND2, X ,Y ),Z = IF (COND1, IF (COND2, X ,Y ),Z =IF (COND1, IF (COND2, X ,Y ),Z =IF (COND1, IF (COND2, X ,Y ),Z I.E =IF (COND1, A, IF (COND 2, B, C) =IF (COND1, A, IF (COND 2, B, C) =IF (COND1, A, IF (COND 2, B, C) =IF (COND1, A, IF (COND 2, B, C) For the conditions to be true And: Both Needs to be true. OR: Either one can be true. < > is Unequal. ...
View Full Document

This note was uploaded on 04/17/2011 for the course MIS 1300 taught by Professor Rezav during the Spring '11 term at University of Houston.

Ask a homework question - tutors are online