Forum Discussion

katkatk's avatar
katkatk
Copper Contributor
May 05, 2019

excel formula

Hi All!    Is anyone able to identify an issue with this formula?   =IF((TODAY()-D5/365.25>=45,G5-VLOOKUP(RIGHT(LEFT(C5,3),2),salary2,2,FALSE)*8%,IF(RIGHT(LEFT(C5,3),2)="(PM) Project Manager",G5-...
excel
Excel on Mac
Excel Online
Formulas and Functions
Twifoo's avatar
Twifoo
Silver Contributor
May 06, 2019
Perhaps, this is the shorter version of the formula you need:
=VLOOKUP(RIGHT(LEFT(C5,3),2),salary2,2,0)*
CHOOSE(((TODAY()-D5)/365.25>0)+(((TODAY()-D5)/365.25>44)*2)+(RIGHT(LEFT(C5,3),2)="PM"),
5%,10%,8%)