IF then statement

[mellie33]

Hi

I am trying to do an IF then statement. I have a list of items that if a cell contains I want it to say Deduct or no deduct, no matter what I try the formula only returns No Deduct. The formula is listed below:

=IF(OR(J876="EXTRA BUNDLING CHARG",J876="SPECIAL PACKAGING", J876="COMBO GASKET TOOL",J876="CUSTOM BUNDLING CHAR", J876="PANEL BREAK",J876="PANEL BREAK BLADE TE",J876="PANEL BREAK BALDE V", J876="SPECIAL BUNDLING CHA",J876="BUNDLING CHARGE"),"DEDUCT","No Deduct")

Any thoughts on what I could be doing wrong?

Thanks,
Melanie

 

[Scott T]

Make sure that J876 is exactly the same was what you have in your formula. If there are extra spaces or non printing characters then you will not get a match.

 

[DanteAmor]

Check the content of J876 and you can also reduce the formula a bit:

=IF(J876={"EXTRA BUNDLING CHARG","SPECIAL PACKAGING","COMBO GASKET TOOL","CUSTOM BUNDLING CHAR","PANEL BREAK","PANEL BREAK BLADE TE","PANEL BREAK BALDE V","SPECIAL BUNDLING CHA","BUNDLING CHARGE"},"DEDUCT","No Deduct")

 

[mellie33]

Thank you - there must have been a spacing issue. When I copied and pasted to the cells, it worked.