Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old January 18th 06, 05:12 AM posted to microsoft.public.excel.worksheet.functions
Holly
 
Posts: n/a
Default Date Comparison and IF statement

I would like to enter a formula to calculate the following

If an employee's date of hire is greater than 10 months from the last day of
the year and their skill level is not greater than or equal to LS2 I want a
return of 2

If their hire date is less than or equal to 12 months from the last day of
the year and their skill level is great than or equal to LO2 i want a return
of 4

A little background: I am using this information to score/grade employees on
knowledge level for year end reviews and will be using this formula from year
to year I would like to not have to update the formula each year with the
correct year end date (In this case I am completing year end reviews for
1/1/05-12/31/05)

  #2   Report Post  
Old January 18th 06, 06:11 AM posted to microsoft.public.excel.worksheet.functions
Biff
 
Posts: n/a
Default Date Comparison and IF statement

Hi!

These are not valid logical expressions:

is not greater than or equal to LS2
is great[er] than or equal to LO2


The logical comparisons you want can only appy to numbers.

<10
=10


<LS2 ??????? What's less than LS2?

Biff

"Holly" wrote in message
...
I would like to enter a formula to calculate the following

If an employee's date of hire is greater than 10 months from the last day
of
the year and their skill level is not greater than or equal to LS2 I want
a
return of 2

If their hire date is less than or equal to 12 months from the last day of
the year and their skill level is great than or equal to LO2 i want a
return
of 4

A little background: I am using this information to score/grade employees
on
knowledge level for year end reviews and will be using this formula from
year
to year I would like to not have to update the formula each year with the
correct year end date (In this case I am completing year end reviews for
1/1/05-12/31/05)



  #3   Report Post  
Old January 18th 06, 06:23 AM posted to microsoft.public.excel.worksheet.functions
Biff
 
Posts: n/a
Default Date Comparison and IF statement

I just realized that those might be cell references!!!!!!!!

Are they?

Biff

"Biff" wrote in message
...
Hi!

These are not valid logical expressions:

is not greater than or equal to LS2
is great[er] than or equal to LO2


The logical comparisons you want can only appy to numbers.

<10
=10


<LS2 ??????? What's less than LS2?

Biff

"Holly" wrote in message
...
I would like to enter a formula to calculate the following

If an employee's date of hire is greater than 10 months from the last day
of
the year and their skill level is not greater than or equal to LS2 I want
a
return of 2

If their hire date is less than or equal to 12 months from the last day
of
the year and their skill level is great than or equal to LO2 i want a
return
of 4

A little background: I am using this information to score/grade employees
on
knowledge level for year end reviews and will be using this formula from
year
to year I would like to not have to update the formula each year with the
correct year end date (In this case I am completing year end reviews for
1/1/05-12/31/05)





  #4   Report Post  
Old January 18th 06, 06:26 AM posted to microsoft.public.excel.worksheet.functions
Biff
 
Posts: n/a
Default Date Comparison and IF statement

Doh!

I just realized that those might be cell references!!!!!!!!


Maybe I should call it a night!

Biff

"Biff" wrote in message
...
I just realized that those might be cell references!!!!!!!!

Are they?

Biff

"Biff" wrote in message
...
Hi!

These are not valid logical expressions:

is not greater than or equal to LS2
is great[er] than or equal to LO2


The logical comparisons you want can only appy to numbers.

<10
=10


<LS2 ??????? What's less than LS2?

Biff

"Holly" wrote in message
...
I would like to enter a formula to calculate the following

If an employee's date of hire is greater than 10 months from the last
day of
the year and their skill level is not greater than or equal to LS2 I
want a
return of 2

If their hire date is less than or equal to 12 months from the last day
of
the year and their skill level is great than or equal to LO2 i want a
return
of 4

A little background: I am using this information to score/grade
employees on
knowledge level for year end reviews and will be using this formula from
year
to year I would like to not have to update the formula each year with
the
correct year end date (In this case I am completing year end reviews for
1/1/05-12/31/05)







  #5   Report Post  
Old January 19th 06, 01:01 AM posted to microsoft.public.excel.worksheet.functions
Holly
 
Posts: n/a
Default Date Comparison and IF statement

I realize after reading the reply that my verbage would have to be corrected
as follows

"Holly" wrote:

I would like to enter a formula to calculate the following

If an employee's date of hire is greater than 10 months from the last day of
the year and their skill level is not equal to LS2 I want a return of 2

If their hire date is less than or equal to 12 months from the last day of
the year and their skill level is equal to LO2 i want a return
of 4

A little background: I am using this information to score/grade employees on
knowledge level for year end reviews and will be using this formula from year
to year I would like to not have to update the formula each year with the
correct year end date (In this case I am completing year end reviews for
1/1/05-12/31/05)



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
How do I lookup data with two comparison values? Tiziano Excel Worksheet Functions 9 December 3rd 05 05:15 AM
Date comparison Jonibenj Excel Discussion (Misc queries) 6 October 23rd 05 08:34 PM
Excel - date comparison stormsailor Excel Discussion (Misc queries) 2 July 19th 05 05:46 AM
Comparison Operators for IF statement. Shams Excel Worksheet Functions 1 February 14th 05 03:35 PM
Date Comparison Driving Me Crazy DTODDP Excel Discussion (Misc queries) 5 January 27th 05 09:39 PM


All times are GMT +1. The time now is 06:27 PM.

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

About Us

"It's about Microsoft Excel"

 

Copyright © 2017