Thursday, December 26, 2013

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.
-------------------------------------------------------------------------------------------------------------------------------------