This preview shows page 1. Sign up to view the full content.
Unformatted text preview: The formula in Card assembles the name as shown. You are required to write ONLY SOME of the formulae. Assume that other cells contain formulae that do what's required there. 1) Show the formula for Rank .  =IF( R_<11, R_, IF( R_=11, "Jack", IF( R_=12, "Queen", IF( R_=13, "King", "Ace")))) A variety of answers will accomplish the task. The keys are: a nested IF structure with 4 IF functions 1 point conditions that identify each of the 5 ranges of R 1 point copying R into Rank for values 2 through 10 1 point assigning the appropriate literal strings for each other value 1 point 2) Create a formula for the Card column. = Rank & of & suit C1...
View Full Document
This note was uploaded on 12/16/2010 for the course CSE CSE 1520 taught by Professor Paul during the Spring '09 term at York University.
- Spring '09