formula that will help with resolving Salary compression in a department

[Glatortue]

with the new minimum DOL treshhold for exempt employees increased to $ 43,888 effective 7/1/24 - I need help to develop a spreadsheet with a formula to fix emps that are impacted as I bring those employees to the to the min of $43888 and provide increases to the employees to resolve compression based on year of service time in position

 

[awoohaw]

welcome to the forum.

Can you provide examples of this scenario? Please provide a starting point, a description of the calculations needed to be done AND and expected result.
More than one example would be helpful.

To answer what you have written:
If the current salary is in cell B2, a formula in cell C2 to give the new salary would be:

=IF(B2<43888,43888,B2)

 

[Joe4]

To answer what you have written:
If the current salary is in cell B2, a formula in cell C2 to give the new salary would be:

=IF(B2<43888,43888,B2)

Or more simply, you could just use:

=MAX(B2,43888)