Thursday, May 21, 2015

yogi_If Name Matches In Column D Of MASTER And Date In Column DH Of Master In The Corresponding Row Is Between Dates In Cells C1 And D1 Then return 0.5 Else 0


                                           Google Spreadsheet   Post  #1961
              Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     www.energyefficientbuild.com.    May 21, 2015
question  by J. Eric Smith:
https://productforums.google.com/forum/#!category-topic/docs/spreadsheets/xldqi1BgpZo
Trying to do a nested If with dates, failing miserably. Please help!
So I have a fairly complex sheet that I'm trying to do too much with, but here I am. I'm trying to write a nested IF statement that will look for a name, if the name matches it then tries to match a date range. If all are true it should return "0.5", else "0"

=If(Master!D:D=A6,if(Master!DH:DH>=$C$1,if(Master!DH:DH<=$D$1,"0.5")),"0")


It's the second sheet "Credits Earned by Date Range"

Thanks in advance for any suggestions or help.

-eric
-------------------------------------------------------------------------------------------------------