xxkaykayxx
New Member
- Joined
- Jan 4, 2017
- Messages
- 4
Hi, would really appreciated any help here. I am trying to forecast salaries. So far the formula can account for any pay rises and bonuses in the right period. I cant figure out how to get the forecast to stop continuing after their end date, within the formula I already have. I feel like this should be a lot simpler than it is. Any help would be greatly appreciated, Ive attached the screenshot.
My current formula: =($J55/12)+((IF((MONTH($K55)<=MONTH(S$2)),(($N55/12)),0)))+((IF(AND($O55>=S$2,$O55<=S$1),$Q55,0)))
My current formula: =($J55/12)+((IF((MONTH($K55)<=MONTH(S$2)),(($N55/12)),0)))+((IF(AND($O55>=S$2,$O55<=S$1),$Q55,0)))