I have this formula in column 'J' named 'Week'. It has this formula below.
[email protected](A2<>"",(IFS(AND(C2>='Pay Rates'!$D$2,C2<='Pay Rates'!$E$2),'Pay Rates'!$F$2,(AND(C2>='Pay Rates'!$D$3,C2<='Pay Rates'!$E$3)),'Pay Rates'!$F$3,(AND(C2>='Pay Rates'!$D$4,C2<='Pay Rates'!$E$4)),'Pay
This displays #NAME? in the cells. If I click on the ribbon, then click the menu name Formulas, and then the button named Insert Function, and click OK on the Function Arguments window, the cell now reads Week 1, Week 2, or Week 3 as it should. This will then allow the calculated data to appear on the "Pay Rates' tab and 'Hourly Summary' tab. I Googled the @ in an Excel formula and this @ in the formula was due to an Implicit Intersection. How can this formula be edited so column 'J' does not display #NAME? I have attached this workbook for review.