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
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.
-------------------------------------------------------------------------------------------------------------------------------------
No comments:
Post a Comment