Nested "IF" With "And"and "OR" functions
 

In Excel 2003, I can't figure out the fomula for a company that has full time
and part time employees who recieve family leave time. For full time
employees who have been employed 1 year or more they get 5 days, if they have
been employed less than 1 year they get 3 days. For part time employees who
have been employed 2 or more years they get 3 days. This needs to be
formulated in 1 cell. Can anybody help me, I'm going crazy with all the
errors in my Syntax.
--
Frustrated

Nested "IF" With "And"and "OR" functions
 

What's your setup like? Do you have a cell to designate the employee's
status: full/part time? Do you have a cell for their length of employment?

Biff

"Richard Freist" wrote in message
...
In Excel 2003, I can't figure out the fomula for a company that has full
time
and part time employees who recieve family leave time. For full time
employees who have been employed 1 year or more they get 5 days, if they
have
been employed less than 1 year they get 3 days. For part time employees
who
have been employed 2 or more years they get 3 days. This needs to be
formulated in 1 cell. Can anybody help me, I'm going crazy with all the
errors in my Syntax.
--
Frustrated

Nested "IF" With "And"and "OR" functions
 

On Feb 2, 8:53 pm, Richard Freist
wrote:
In Excel 2003, I can't figure out the fomula for a company that has full time
and part time employees who recieve family leave time. For full time
employees who have been employed 1 year or more they get 5 days, if they have
been employed less than 1 year they get 3 days. For part time employees who
have been employed 2 or more years they get 3 days. This needs to be
formulated in 1 cell. Can anybody help me, I'm going crazy with all the
errors in my Syntax.

The following structure should help:

=if(status="full time", if(lengthOfService=1, 5, 3),
if(lengthOfService=2, 3, 0))

Nested "IF" With "And"and "OR" functions
 

Let's say column B is full time employees, and column C is part time employees.

Formula for full time employee
=IF(B2=1,5,3)

Formula for part time employee
=IF(C2=2,3,0)


"Richard Freist" wrote:

In Excel 2003, I can't figure out the fomula for a company that has full time
and part time employees who recieve family leave time. For full time
employees who have been employed 1 year or more they get 5 days, if they have
been employed less than 1 year they get 3 days. For part time employees who
have been employed 2 or more years they get 3 days. This needs to be
formulated in 1 cell. Can anybody help me, I'm going crazy with all the
errors in my Syntax.
--
Frustrated