Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
year 2010 not working in IF
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!AX 4<Information!$H$17),Information!$B$18,IF(AND($H2= "A",EmployeeData!AX4<Information!$H$21),Informatio n!$B$22,IF(AND($H2="A",EmployeeData!AX4<Informatio n!$H$25)<Information!$B$26,IF(AND($H2="A",Employee Data!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. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
year 2010 not working in IF
Hi
What you have 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"))))) In the 4th and 5th lines, you have < in place of , -- Regards Roger Govier "SLP" wrote in message ... 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!AX 4<Information!$H$17),Information!$B$18,IF(AND($H2= "A",EmployeeData!AX4<Information!$H$21),Informatio n!$B$22,IF(AND($H2="A",EmployeeData!AX4<Informatio n!$H$25)<Information!$B$26,IF(AND($H2="A",Employee Data!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. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
year 2010 not working in IF
Thank you. I caught that as soon as I posted. Guess its time I go home for
the day :) "Roger Govier" wrote: Hi What you have 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"))))) In the 4th and 5th lines, you have < in place of , -- Regards Roger Govier "SLP" wrote in message ... 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!AX 4<Information!$H$17),Information!$B$18,IF(AND($H2= "A",EmployeeData!AX4<Information!$H$21),Informatio n!$B$22,IF(AND($H2="A",EmployeeData!AX4<Informatio n!$H$25)<Information!$B$26,IF(AND($H2="A",Employee Data!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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Formula for the first working day of the year | Excel Worksheet Functions | |||
Macro not working at year end | Excel Discussion (Misc queries) | |||
Macro not working at year end | Excel Discussion (Misc queries) | |||
For dates, copy/paste special/values for 2006 gives me 2010--Why | Excel Worksheet Functions | |||
Calculation with Working day of the year | Excel Discussion (Misc queries) |