BrianM
Well-known Member
- Joined
- Jan 15, 2003
- Messages
- 768
- Office Version
- 2016
- Platform
- Windows
Could anyone explain why the formula in G16 does not work, but the one in G15 does... Thanks
Book3.xls | |||||||||
---|---|---|---|---|---|---|---|---|---|
A | B | C | D | E | F | G | |||
8 | EMPLOYEEID | ACCRUAL | ACCRUALTRANTYPENAME | Expr1 | EFFECTIVEDATE | Balance | Call In Vac | ||
9 | 4444 | Call In Vac | GRANT | 5 | 1/1/2005 | ||||
10 | 4444 | Personal | GRANT | 40 | 1/1/2005 | ||||
11 | 4444 | Personal | TAKEN | -8 | 1/6/2005 | ||||
12 | 4444 | School Leave | GRANT | 8 | 1/1/2005 | ||||
13 | 4444 | Vacation | GRANT | 184 | 1/1/2005 | ||||
14 | 4444 | Vacation | TAKEN | -8 | 1/24/2005 | ||||
15 | 4444 Total | 2/11/2530 | 5 | ||||||
16 | 4445 | Call In Vac | GRANT | 5 | 1/1/2005 | 10 | |||
17 | 4445 | Personal | GRANT | 40 | 1/1/2005 | ||||
18 | 4445 | School Leave | GRANT | 8 | 1/1/2005 | ||||
19 | 4445 | Vacation | GRANT | 184 | 1/1/2005 | ||||
20 | 4445 | WildCard | GRANT | 8 | 2/4/2005 | ||||
21 | 4445 Total | 2/14/2425 | |||||||
Sheet1 |