Converting excel formula to function

I'm having trouble converting the below formula from excel to smartsheets.

The biggest issue I'm having is the +1(take from the cell to the right of the Vlookup result) and *-1(make the result value negative). So far I have this but keep getting #No Match

How would I go about fixing this?

Thank you!

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!