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.
|