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

[Guest]

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.

 

[T. Valko]

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?

 

[Guest]

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

 

[T. Valko]

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

 

[Guest]

thanks so much- that was great help!

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

 

[T. Valko]

You're welcome. Thanks for the feedback!