software

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)

Hi!

These are not valid logical expressions:

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

The logical comparisons you want can only appy to numbers.

lt;10
gt;=10

lt;LS2 ??????? What's less than LS2?

Biff

quot;Hollyquot; gt; wrote in message
...
gt;I would like to enter a formula to calculate the following
gt;
gt; If an employee's date of hire is greater than 10 months from the last day
gt; of
gt; the year and their skill level is not greater than or equal to LS2 I want
gt; a
gt; return of 2
gt;
gt; If their hire date is less than or equal to 12 months from the last day of
gt; the year and their skill level is great than or equal to LO2 i want a
gt; return
gt; of 4
gt;
gt; A little background: I am using this information to score/grade employees
gt; on
gt; knowledge level for year end reviews and will be using this formula from
gt; year
gt; to year I would like to not have to update the formula each year with the
gt; correct year end date (In this case I am completing year end reviews for
gt; 1/1/05-12/31/05)
I just realized that those might be cell references!!!!!!!!

Are they?

Biff

quot;Biffquot; gt; wrote in message
...
gt; Hi!
gt;
gt; These are not valid logical expressions:
gt;
gt;gt;is not greater than or equal to LS2
gt;gt;is great[er] than or equal to LO2
gt;
gt; The logical comparisons you want can only appy to numbers.
gt;
gt; lt;10
gt;gt;=10
gt;
gt; lt;LS2 ??????? What's less than LS2?
gt;
gt; Biff
gt;
gt; quot;Hollyquot; gt; wrote in message
gt; ...
gt;gt;I would like to enter a formula to calculate the following
gt;gt;
gt;gt; If an employee's date of hire is greater than 10 months from the last day
gt;gt; of
gt;gt; the year and their skill level is not greater than or equal to LS2 I want
gt;gt; a
gt;gt; return of 2
gt;gt;
gt;gt; If their hire date is less than or equal to 12 months from the last day
gt;gt; of
gt;gt; the year and their skill level is great than or equal to LO2 i want a
gt;gt; return
gt;gt; of 4
gt;gt;
gt;gt; A little background: I am using this information to score/grade employees
gt;gt; on
gt;gt; knowledge level for year end reviews and will be using this formula from
gt;gt; year
gt;gt; to year I would like to not have to update the formula each year with the
gt;gt; correct year end date (In this case I am completing year end reviews for
gt;gt; 1/1/05-12/31/05)
gt;
gt;
Doh!

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

Maybe I should call it a night!

Biff

quot;Biffquot; gt; wrote in message
...
gt;I just realized that those might be cell references!!!!!!!!
gt;
gt; Are they?
gt;
gt; Biff
gt;
gt; quot;Biffquot; gt; wrote in message
gt; ...
gt;gt; Hi!
gt;gt;
gt;gt; These are not valid logical expressions:
gt;gt;
gt;gt;gt;is not greater than or equal to LS2
gt;gt;gt;is great[er] than or equal to LO2
gt;gt;
gt;gt; The logical comparisons you want can only appy to numbers.
gt;gt;
gt;gt; lt;10
gt;gt;gt;=10
gt;gt;
gt;gt; lt;LS2 ??????? What's less than LS2?
gt;gt;
gt;gt; Biff
gt;gt;
gt;gt; quot;Hollyquot; gt; wrote in message
gt;gt; ...
gt;gt;gt;I would like to enter a formula to calculate the following
gt;gt;gt;
gt;gt;gt; If an employee's date of hire is greater than 10 months from the last
gt;gt;gt; day of
gt;gt;gt; the year and their skill level is not greater than or equal to LS2 I
gt;gt;gt; want a
gt;gt;gt; return of 2
gt;gt;gt;
gt;gt;gt; If their hire date is less than or equal to 12 months from the last day
gt;gt;gt; of
gt;gt;gt; the year and their skill level is great than or equal to LO2 i want a
gt;gt;gt; return
gt;gt;gt; of 4
gt;gt;gt;
gt;gt;gt; A little background: I am using this information to score/grade
gt;gt;gt; employees on
gt;gt;gt; knowledge level for year end reviews and will be using this formula from
gt;gt;gt; year
gt;gt;gt; to year I would like to not have to update the formula each year with
gt;gt;gt; the
gt;gt;gt; correct year end date (In this case I am completing year end reviews for
gt;gt;gt; 1/1/05-12/31/05)
gt;gt;
gt;gt;
gt;
gt;
I realize after reading the reply that my verbage would have to be corrected
as follows

quot;Hollyquot; wrote:

gt; I would like to enter a formula to calculate the following
gt;
gt; If an employee's date of hire is greater than 10 months from the last day of
gt; the year and their skill level is not equal to LS2 I want a return of 2
gt;
gt; If their hire date is less than or equal to 12 months from the last day of
gt; the year and their skill level is equal to LO2 i want a return
gt; of 4
gt;
gt; A little background: I am using this information to score/grade employees on
gt; knowledge level for year end reviews and will be using this formula from year
gt; to year I would like to not have to update the formula each year with the
gt; correct year end date (In this case I am completing year end reviews for
gt; 1/1/05-12/31/05)