how do you find the earliest date when using an IF function?
 

I have a worksheet that lists the dates of that every employee begins working
at a company; a bonus of 1000 dollars is being given to the employee who has
started working at the earliest date while the other get no bonus (0
dollars). I need to find a formula that uses the IF function to pick out the
earliest date and then give them 1000 dollar bonus and others 0 dollars bonus.

how do you find the earliest date when using an IF function?
 

Well, it depends on how you want to do this.

Do you want one formula to return the name of the most senior employee or do
you want a formula next to each employee name that returns either the bonus
amount or a 0?

--
Biff
Microsoft Excel MVP


"ree" wrote in message
...
I have a worksheet that lists the dates of that every employee begins
working
at a company; a bonus of 1000 dollars is being given to the employee who
has
started working at the earliest date while the other get no bonus (0
dollars). I need to find a formula that uses the IF function to pick out
the
earliest date and then give them 1000 dollar bonus and others 0 dollars
bonus.

how do you find the earliest date when using an IF function?
 

I would like a formula that returns either the bonus or 0 for each employee
in a separate column. Thank you

"T. Valko" wrote:

Well, it depends on how you want to do this.

Do you want one formula to return the name of the most senior employee or do
you want a formula next to each employee name that returns either the bonus
amount or a 0?

--
Biff
Microsoft Excel MVP


"ree" wrote in message
...
I have a worksheet that lists the dates of that every employee begins
working
at a company; a bonus of 1000 dollars is being given to the employee who
has
started working at the earliest date while the other get no bonus (0
dollars). I need to find a formula that uses the IF function to pick out
the
earliest date and then give them 1000 dollar bonus and others 0 dollars
bonus.

how do you find the earliest date when using an IF function?
 

Here's one way.

Assume names in the range A1:A10
Hire dates in the range B1:B10

Enter this formula in C1 and copy down to C10:

=(B1=MIN(B$1:B$10))*1000

--
Biff
Microsoft Excel MVP


"ree" wrote in message
...
I would like a formula that returns either the bonus or 0 for each employee
in a separate column. Thank you

"T. Valko" wrote:

Well, it depends on how you want to do this.

Do you want one formula to return the name of the most senior employee or
do
you want a formula next to each employee name that returns either the
bonus
amount or a 0?

--
Biff
Microsoft Excel MVP


"ree" wrote in message
...
I have a worksheet that lists the dates of that every employee begins
working
at a company; a bonus of 1000 dollars is being given to the employee
who
has
started working at the earliest date while the other get no bonus (0
dollars). I need to find a formula that uses the IF function to pick
out
the
earliest date and then give them 1000 dollar bonus and others 0 dollars
bonus.

how do you find the earliest date when using an IF function?
 

thanks so much- that was great help!

"T. Valko" wrote:

Here's one way.

Assume names in the range A1:A10
Hire dates in the range B1:B10

Enter this formula in C1 and copy down to C10:

=(B1=MIN(B$1:B$10))*1000

--
Biff
Microsoft Excel MVP


"ree" wrote in message
...
I would like a formula that returns either the bonus or 0 for each employee
in a separate column. Thank you

"T. Valko" wrote:

Well, it depends on how you want to do this.

Do you want one formula to return the name of the most senior employee or
do
you want a formula next to each employee name that returns either the
bonus
amount or a 0?

--
Biff
Microsoft Excel MVP


"ree" wrote in message
...
I have a worksheet that lists the dates of that every employee begins
working
at a company; a bonus of 1000 dollars is being given to the employee
who
has
started working at the earliest date while the other get no bonus (0
dollars). I need to find a formula that uses the IF function to pick
out
the
earliest date and then give them 1000 dollar bonus and others 0 dollars
bonus.

how do you find the earliest date when using an IF function?
 

You're welcome. Thanks for the feedback!

--
Biff
Microsoft Excel MVP


"ree" wrote in message
...
thanks so much- that was great help!

"T. Valko" wrote:

Here's one way.

Assume names in the range A1:A10
Hire dates in the range B1:B10

Enter this formula in C1 and copy down to C10:

=(B1=MIN(B$1:B$10))*1000

--
Biff
Microsoft Excel MVP


"ree" wrote in message
...
I would like a formula that returns either the bonus or 0 for each
employee
in a separate column. Thank you

"T. Valko" wrote:

Well, it depends on how you want to do this.

Do you want one formula to return the name of the most senior employee
or
do
you want a formula next to each employee name that returns either the
bonus
amount or a 0?

--
Biff
Microsoft Excel MVP


"ree" wrote in message
...
I have a worksheet that lists the dates of that every employee begins
working
at a company; a bonus of 1000 dollars is being given to the employee
who
has
started working at the earliest date while the other get no bonus (0
dollars). I need to find a formula that uses the IF function to pick
out
the
earliest date and then give them 1000 dollar bonus and others 0
dollars
bonus.