LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
ree ree is offline
external usenet poster
 
Posts: 4
Default 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.
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Earliest date using WEEKNUMBER Jock Excel Worksheet Functions 3 September 17th 07 10:17 AM
Find earliest date combined with status Ixtreme Excel Discussion (Misc queries) 2 August 28th 07 04:14 AM
How do I find the earliest date? Dave Shultz Excel Discussion (Misc queries) 1 May 11th 07 06:45 PM
Find the earliest date in a range of dates? Rachel Williams Excel Worksheet Functions 2 February 10th 06 03:50 PM
Earliest Date to populate? sonquizzon Excel Worksheet Functions 2 June 16th 05 07:35 PM


All times are GMT +1. The time now is 08:18 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"