Score Weight
0,1 or 2 0%, 10% or 20%

I need help with a conditional formula to determine if a scores is 0 thru 2. A zero score should equal "0%", a one score should equal 10%, and a 2 should equal 20%.


=IF (D9 = "0", 0)
=IF (D9 = "1", 10%)
=IF (D9 = "2", 20%)

How do I fit that into one cell as a single formula?

Help! - Ces