Fixing a #REF! error

#REF! is one of the most common Excel error messages. It means that your spreadsheet has a problem with a reference to another cell.

Tradinformed models use linked formulas which means that one small #REF! error quickly spreads throughout the model.

In this video, I demonstrate how to find and remove #REF! errors. Usually this is a quick process!

Next Step

Learn how to: Use the Optimizer Tab!