Help formatting a IF AND Does not equal expression

Avogadro

Board Regular
Joined
Apr 29, 2010
Messages
59
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")
 

Special-K99

Well-known Member
Joined
Nov 7, 2006
Messages
8,328
=IF(AND(oknshipstate="NJ",okncreditcard<>"Amazon","","No ")&"Tax"
 
Last edited:

AlanY

Well-known Member
Joined
Oct 30, 2014
Messages
3,970
Office Version
365, 2019, 2016
Platform
Windows
fill in "?" when oknshipstate in not "NJ"

=IF(oknshipstate="NJ",if(okncreditcard="Amazon","No Tax", "Tax"),"?")
 

Avogadro

Board Regular
Joined
Apr 29, 2010
Messages
59
That worked :)
=IF(oknshipstate="NJ",IF(okncreditcard="Amazon","No Tax", "Tax"),"No Tax")

Thanks
 

Forum statistics

Threads
1,082,585
Messages
5,366,466
Members
400,892
Latest member
lamarh755

Some videos you may like

This Week's Hot Topics

Top