Forum Discussion

gclarke's avatar
gclarke
Copper Contributor
Nov 05, 2021
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...
Formulas and Functions
  • Twifoo's avatar
    Twifoo
    Nov 06, 2021

    gclarke 

    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?

Riny_van_Eekelen's avatar
Riny_van_Eekelen
Platinum Contributor
Nov 06, 2021

gclarke In H13, try this:

=IF($F13<=H$8,$E13*(1+$C$4)^INT(DATEDIF($F13,H$8,"m")/12)/12,0)

Copy down and across. I'm not a big fan of the DATEDIF function, but in this case it works just fine. 

  • gclarke's avatar
    gclarke
    Copper Contributor
    Nov 06, 2021
    Riny Thank as well, I appreciate the assistance

Resources