Forum Discussion
Solved
Need Help with a Nest Formula
I have a formula that will look at the start date of a hire, the starting salary and then increment the salary by a referenced percentage upon the anniversary of start date. However, the formula onl...
As I illustrated in the attached version of your file, the formula in H13 is:
=IF(H$8<$F13,0,
($E13/12)*(1+$C$4)^
INT(YEARFRAC($F13,H$8-1,1)))
It's my pleasure to have enabled you to learn something. This is my first time to make a request from someone whom I've somehow helped. Could you kindly mark my previous reply as Best Response so that the number of my Best Responses crosses the two-digit line?
- Absolutely! Done, and thank you again.