Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
SLP SLP is offline
external usenet poster
 
Posts: 58
Default 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   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 2,480
Default 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   Report Post  
Posted to microsoft.public.excel.misc
SLP SLP is offline
external usenet poster
 
Posts: 58
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Formula for the first working day of the year Ron@Buy Excel Worksheet Functions 13 April 27th 23 07:49 PM
Macro not working at year end Paul S Excel Discussion (Misc queries) 2 January 21st 07 12:27 AM
Macro not working at year end Paul S Excel Discussion (Misc queries) 0 January 19th 07 11:48 AM
For dates, copy/paste special/values for 2006 gives me 2010--Why geraldjoh Excel Worksheet Functions 3 July 23rd 06 01:12 AM
Calculation with Working day of the year Box666 Excel Discussion (Misc queries) 4 November 10th 05 07:33 PM


All times are GMT +1. The time now is 12:20 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"