If statement problem

[jgold20]

=IF(OR(A4="WL"),("0"),0) +
IF(OR(A4="BL",A4="DL",A4="LL",A4="LGL",A4="NL",A4="MDL",A4="RL",A4="WGL",A4="XL",
A4="A",A4="B",A4="CB",A4="D",A4="K",A4="V",A4="X",
A4="H",A4="L",A4="LG",A4="M",A4="MD",
A4="N",A4="Q",A4="R",A4="T",A4="W",A4="WG",A4="Y"),(A7*B7),0)

In the above statement, only BL, DL, H, LGL, MD, MDL, NL and X are performing properly. All of the others do not return any results. Any suggestions?

 

[steve the fish]

Just put those formulas in a cell anywhere on the worksheet. What are the results?

 

[steve the fish]

=A4="A" returned false
=CLEAN(TRIM(A4))="A" returned true

Ok so thats your problem. You need to check your drop down values. Id use the clean trim formula on those values and copy/ paste the result over the top.