How to analyze missing "If false" parts of nested IF formulas

EDIT: I realize I need to rewrite the formula below to include an AND statement. Please disregard until I can try to fix the problem. I will update this post when I'm done.
EDIT #2. I solved the problem. The formula which works for my needs (if anyone really wants to know!) is:

Please Login or Register  to view this content.

I often write nested IF formulas, and sometimes wind up with one which has a missing "if false" part. That part is almost always a

Please Login or Register  to view this content.

.

I detect the problem when using it in a workbook which returns "FALSE" in the formula's cell instead of what I want, which is a "0."

Usually I try to analyze the problem by breaking down the complete, nested formula into its components: One "IF" formula per line, which I paste into Windows Notepad.

I also look at the end of the formula where there are multiple ")" such as

Please Login or Register  to view this content.

. If I move the cursor between each ")" I'll see the helper info stating "value if true" or "value if false."

But the following formula has me stumped. Can you catch the error... and/or give me any hints on how to detect the missing "0" when I write these formulas in the future? (Or do you need more info to help me?)

Please Login or Register  to view this content.

Thanks

Have you stepped thru the formula using the Evaluate?

Evaluate Formula

• Click on the cell with the formula >> Ribbon >> Formulas >> Formula Auditing >> Evaluate Formula

right now you are missing a few if true parts...
so what do you want if BX47="S" and same if BX47="L"?
otherwise you might have to decide if those are part of an OR or AND statement to include in your formula.

I think that they currently are acting as AND statements.

glad you resolved it.

AND thank you for the rep!