| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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. |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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. |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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. |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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. |
|
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Earliest date using WEEKNUMBER | Excel Worksheet Functions | |||
| Find earliest date combined with status | Excel Discussion (Misc queries) | |||
| How do I find the earliest date? | Excel Discussion (Misc queries) | |||
| Find the earliest date in a range of dates? | Excel Worksheet Functions | |||
| Earliest Date to populate? | Excel Worksheet Functions | |||
Linear Mode
