I am creating a self-accruing absentee calendar for employees. I am having a problem with a formula; =IF((I7>(E7))(Y26*M$8)). This means that if the date in I7 is greater than the date in E7, vacation should accrue for hours worked(Y26) times rate(M$8). This contains an error.
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
Formula????
- Thread starter mermar
- Start date
VoG
Legend
- Joined
- Jun 19, 2002
- Messages
- 63,650
Duplicate of http://www.mrexcel.com/forum/showthread.php?t=577610
Please do not post the same question multiple times. All clarifications, follow-ups, and bumps should be posted back to the original thread. Per forum rules, posts of a duplicate nature will be locked or deleted (rule #9 here: http://www.mrexcel.com/forum/showthread.php?t=99490).
Please do not post the same question multiple times. All clarifications, follow-ups, and bumps should be posted back to the original thread. Per forum rules, posts of a duplicate nature will be locked or deleted (rule #9 here: http://www.mrexcel.com/forum/showthread.php?t=99490).
Upvote
0
- Status
Similar threads
