I have an array of Date Ranges (Beginning and End Dates in two columns); I need to determine in which "week" a specified resides, and display the Amount (which is held in a third column.
I have this formula to do so:
=IF(AND(B11 <G36 >F36),K36,0)
It works fine for one row in the array of dates, however when I replace the "else" argument with an exact copy of the formula (with the exception of "cell references" being changed I get an #NAME result.
=IF(AND(B11 <G36 >F36),K36,=IF(AND(B11 <G36 >F36),K36,0))
Any suggestions would be great.
I have this formula to do so:
=IF(AND(B11 <G36 >F36),K36,0)
It works fine for one row in the array of dates, however when I replace the "else" argument with an exact copy of the formula (with the exception of "cell references" being changed I get an #NAME result.
=IF(AND(B11 <G36 >F36),K36,=IF(AND(B11 <G36 >F36),K36,0))
Any suggestions would be great.