Evaluate Formula
If you have a complicated formula and it is giving you an error or not the answer you expected, Excel has an Evaluate Formula tool.
This is available from the tools menu under Formula Auditing or from the Formula Auditing toolbar shown here. The evaluate formula button is on the right.
Excel Formula Auditing
This tool evaluates each part of the formula in turn showing you how outcomes. It is then possible to see where your error or unexpected result is coming from.
