yogi_For An Entry In Cell A1 LookUp Value In Column 2 Of Virtual Table Made From Table Of Data By User

                                          Google Spreadsheet   Post  #1451
Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     www.energyefficientbuild.com.   Dec-27, 2013
question by Jennifer Travlos (http://productforums.google.com/forum/?zx=wh33mpxca23w#!category-topic/docs/spreadsheets/tSAHJBd7eH0)
Multiple If Then's with multiple conditions

Hi all. I understand the basic concept of an "if then" statement. I'm having an issue with multiple conditions. I have column A that states any number of 1 through 21. In column B I want it to automatically write a percentage:

21 = .1

20 = .09

19 = .08

18 = .07

17 = .06

16 = .05

15 = .04

14 and under = 0

So if A says 21 B would say .1. If A says 13 B would say 0. If A says 18 B would say .07.

Does anyone have an idea how to do this? Hopefully I am writing this clearly.

-------------------------------------------------------------------------------------------------------------------------------------