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

R

ree

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

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?
 
R

ree

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

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
 
R

ree

thanks so much- that was great help!

T. Valko said:
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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top