May 05 2019 11:03 PM
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-VLOOKUP(RIGHT(LEFT(C5,3),2),salary2,2,FALSE)*10%,G5-VLOOKUP(RIGHT(LEFT(C5,3),2),salary2,2,FALSE)*5%))
May 06 2019 12:34 AM
@katkatk ,
better to have some sample of what you'd like to calculate.
TODAY()-D5/365.25
If in D5 is some date it will be always more than 45, perhaps you mean TODAY()-D5
RIGHT(LEFT(C5,3),2)
returns 2nd and 3rd characters from the text in C5, it never will be equal to "(PM) Project Manager"
May 06 2019 03:25 AM