S
SLP
Hi. I have a nested IF statement that works just fine until the date changes
to any date including and past 1/1/2010. The IF statement is:
=IF(AND($H2="A",EmployeeData!AX4<Information!$H$12),Information!$B$14,IF(AND($H2="A",EmployeeData!AX4<Information!$H$17),Information!$B$18,IF(AND($H2="A",EmployeeData!AX4<Information!$H$21),Information!$B$22,IF(AND($H2="A",EmployeeData!AX4<Information!$H$25)<Information!$B$26,IF(AND($H2="A",EmployeeData!AX4<Information!$H$29)<Information,$B$30,"0")))))
The EmployeeData sheet lists the months for salaries. The information sheet
lists the Health Plan amounts. The formula works great unless the dates on
the EmployeeData sheet are in the years 2010 or higher.
Any ideas on what is happening? Thanks in advance.
to any date including and past 1/1/2010. The IF statement is:
=IF(AND($H2="A",EmployeeData!AX4<Information!$H$12),Information!$B$14,IF(AND($H2="A",EmployeeData!AX4<Information!$H$17),Information!$B$18,IF(AND($H2="A",EmployeeData!AX4<Information!$H$21),Information!$B$22,IF(AND($H2="A",EmployeeData!AX4<Information!$H$25)<Information!$B$26,IF(AND($H2="A",EmployeeData!AX4<Information!$H$29)<Information,$B$30,"0")))))
The EmployeeData sheet lists the months for salaries. The information sheet
lists the Health Plan amounts. The formula works great unless the dates on
the EmployeeData sheet are in the years 2010 or higher.
Any ideas on what is happening? Thanks in advance.