LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 10
Default Length of Service and Vacation Hours Accrued

IF Statement would be If 0-60 months 8 Hours accrued each month, if
61-120 months 10 hours accrued each month, If 121-180 months 12 hours
accrued each month, if more than 181 months then 14 hours accrued each
month. When I try to put in an argument I get an error message.

**This accrual amount for each month must be used in the monthly column if
the worksheet for that month has 100% for the hours worked in cell C02 of
each month.

i.e.,:

Column A Column B
(Month) (Earned)**
JULY-08 ________ (see the description above)
AUG-08
SEPT-08
OCT-08
NOV-08


 
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
Need Formula for Calculating Accrued Vacation Time jd_dps[_2_] Excel Worksheet Functions 2 December 26th 08 08:28 PM
Vacation Accrued SilviaG Excel Discussion (Misc queries) 4 June 5th 08 03:08 PM
How do I add "accrued vacation days" column to the Employee Attend Jam Excel Worksheet Functions 4 February 5th 08 06:06 AM
Length of Service Dom Excel Worksheet Functions 7 July 17th 06 10:47 PM
Accrued Vacation Kim Campbell via OfficeKB.com Excel Worksheet Functions 8 January 12th 05 03:01 PM


All times are GMT +1. The time now is 09:52 PM.

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"