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    May 21, 2015
question  by J. Eric Smith:!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"


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

Thanks in advance for any suggestions or help.