Hint:

Use the Formula Auditing|Evaluate tool found in Tools menu to step through the formula and see what is happening.