LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
MIchel Khennafi
 
Posts: n/a
Default If formula to test several conditions

Good evening Excel Gurus

In a situation where I want to determine the number of vacation days an
employees would have...

In A1 I have the hire date
In B1 I want to determine the number of days of vacation the person may have
using the following conditions:
- From 0 to 6 months -- 0 Days
- From 6 months to less than 1 -- 5 days
- From 1 to Less than 5 -- 10 days
- From 5 to less than 12 -- 5 days
- From 12 to 20 -- 20 days

This situation is a challenge because in the cell B1
- I need to determine the number of year/months/days based on today's date
compared to the HIRE DATE in A1
- I need to have several "if" condition tested at the same time

Can someone help?

Thanks so much



 
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
Format cells with a formula (7 conditions). danindenver Excel Discussion (Misc queries) 3 January 2nd 06 02:40 PM
Match then lookup Tenacity Excel Worksheet Functions 9 December 3rd 05 05:30 AM
Formula checking multiple worksheets sonic-the-mouse Excel Worksheet Functions 2 June 5th 05 07:48 PM
Formula checking multiple worksheets sonic-the-mouse Excel Worksheet Functions 2 June 5th 05 03:28 AM
Formula to return cell contents based on multiple conditions Bill Excel Worksheet Functions 3 January 19th 05 09:59 AM


All times are GMT +1. The time now is 03:14 AM.

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

About Us

"It's about Microsoft Excel"