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?
Help Article Resources
Check out the Formula Handbook template!