Excel Flashcards Preview

MIS Test 1 > Excel > Flashcards

Flashcards in Excel Deck (2):
1

Vlookup

=VLOOKUP(celltobelookedup,Table:oflookup,whichcolumnofthelookuptableanswerwiollbefoundin)

2

describe a nested if statement

IF(B9>18,"Adult", IF(B9>12, "Teen","Chlid"))
IF(condition,"Txtiftrue",IF(condition,"Txtiftrue","Txtiffalse"))