help adding an AND to my if or statement!

[pcorpz]

=IF(OR([@[Item Group]]="Labor",[@[Item Group]]="Labor - 3rd Party",[@[Item Group]]="Sub Contracts", [@[Item Group]]="Cloud Services"),[@[Total Sales]]*0.8,[@[Total Cost]])

I want to add another condition to only the "Labor" item group... and the condition is [@[Item No]] does not equal "Paid by Credit Card-Cloud" OR "Paid by Credit Card-Labor" .. How can I incorporate this?

 

[DanteAmor]

Try this:

=IF(OR(AND([@[Item Group]]="Labor",[@[Item No]]<>"Paid by Credit Card-Cloud",[@[Item No]]<>"Paid by Credit Card-Labor"),[@[Item Group]]="Labor - 3rd Party",[@[Item Group]]="Sub Contracts", [@[Item Group]]="Cloud Services"),[@[Total Sales]]*0.8,[@[Total Cost]])

 

[pcorpz]

Try this:

=IF(OR(AND([@[Item Group]]="Labor",[@[Item No]]<>"Paid by Credit Card-Cloud",[@[Item No]]<>"Paid by Credit Card-Labor"),[@[Item Group]]="Labor - 3rd Party",[@[Item Group]]="Sub Contracts", [@[Item Group]]="Cloud Services"),[@[Total Sales]]*0.8,[@[Total Cost]])

Dante, this works! Learned something new. Thanks!!!!

 

[DanteAmor]

I'm glad to help you. Thanks for the feedback.