Read through this before watching the Video! You need to understand how the formatting works before trying to translate the formulas into something Excel will understand.

Piecewise Linear Functions (Google Doc)