Forum Discussion

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...

Example of Issue.xlsx72 KB

Formulas and Functions

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?

Twifoo

Silver Contributor

Nov 06, 2021

gclarke

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)))

Annual Increase in Monthly Salary.xlsx70 KB

gclarke
Copper Contributor
Nov 06, 2021
Twifoo Much gratitude! Always nice to learn something!
- Twifoo
  Silver Contributor
  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?
  - gclarke
    Copper Contributor
    Nov 06, 2021
    Absolutely! Done, and thank you again.