Hello,
I am looking for assistance in adding to the formula below.
=IF(OR(A3="",C3=""),"",IF(D3="No",1,IF(D3="Yes",2,0))*VLOOKUP(C3,'Employee Search'!$C$3:$D$19,2,FALSE))
What I need to add is IF(E3<>"No") to minus 1 from the total returned from the formula above. If it is no, do nothing or minus 0.
When trying to add that in, I keep getting errors.
I appreciate any help.
Thank you,
Nick
Bookmarks