Logical test argument answer = true for different cell value

Here is my formula:

=IF(B2="JW",SUM(X2*$C$85),IF(B2="PA",SUM(X2*$C$95),IF(B2="CW1",SUM(X2*$C$95),IF(B2="",)))



I want it to do the SUM if B2= CW1, CW2, CW3, CW4 or CW5.

Can there be a "CW6" in B2 (or some other code that starts with CW)?

If not, you could do this:

=IF(B2="JW",X2*$C$85,IF(B2="PA",X2*$C$95,IF(LEFT(B2,2)="CW",X2*$C$95,IF(B2="",))))

Note: you don't need the SUM functions.

Hope this helps.

Pete

There can be just a CW code.

Thanks for the SUM tip , I'm trying to rewrite and old work sheet that someone else did and I'm not that good with excel myself but I seem to always have to learn something by being thrown into the fire...

Then you could do this to exclude the value of "CW":

=IF(B2="JW",X2*$C$85,IF(B2="PA",X2*$C$95,IF(AND(LEN(B2)=3,LEFT(B2,2)="CW"),X2*$C$95,IF(B2="",))))

(changes in red).

Hope this helps.

Pete

Thank you for the help.