Can someone help me format this expression correctly?
If the state is NJ and the credit card is Amazon then No tax but if the state is NJ and the credit card is anything other than Amazon then tax.
=IF(AND(oknshipstate="NJ",okncreditcard="Amazon"),"No Tax", if (AND(oknshipstate="NJ",okncreditcard=does not equal "Amazon"),"Tax")
If the state is NJ and the credit card is Amazon then No tax but if the state is NJ and the credit card is anything other than Amazon then tax.
=IF(AND(oknshipstate="NJ",okncreditcard="Amazon"),"No Tax", if (AND(oknshipstate="NJ",okncreditcard=does not equal "Amazon"),"Tax")