Saturday, July 19, 2014

yogi_If Cell A1 Equals Any of The Entries In Cells C1 C2 C3 Then Compute B1 As D1 D2 D3

                                 Google Spreadsheet   Post  #1699
Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     www.energyefficientbuild.com.   Jul-18-2014
post by hellokevinlee:
(https://productforums.google.com/forum/#!category-topic/docs/spreadsheets/how-do-i/chrome-browser/WYvTsBgGvJI)
If Cell has specific number, return text/number in another cell
Hi there :)

I'm trying to input a formula that can read from one column of numbers and in the adjacent cell next to it on the right, it would spit out a specific number based on the value of a cell in the column next to it.

Example
If A1 reads any of the following numbers (0,13,22,27,28) B1 would return "-60"
If A1 reads any of the following numbers (1,2,3,4,5,6,7,8,9,10,11,12) B1 would return "0"
If A1 reads any of the following numbers (14,15,16,17,18,19,20,21,23,24,25,26,29,30,31,32,33,34,35,36) B1 would return "12"

I believe this is something like an IF(ISNUMBER(Search)) Function but I can't seem to figure this one out.

Please give me the function code exactly able to copy and paste using the IF statements using the real numbers above.

Anyone who can help , thank you!
---------------------------------------------------------------------------------------------------------------------------------