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
- Spring '09
- Jack, Playing card, point point point, Construct Excel Formulas