is this correct? =IF(E89={ "","","" },0,G89*8.625%)

RPATT

New Member
Joined
Mar 14, 2012
Messages
13
=IF(E89={"Food Item Non-Taxable","Misc. Item Non-Taxable","Misc. Open Item Non-Taxable"},0,G89*8.625%)
 

Some videos you may like

Excel Facts

Why does 9 mean SUM in SUBTOTAL?
It is because Sum is the 9th alphabetically in Average, Count, CountA, Max, Min, Product, StDev.S, StDev.P, Sum, VAR.S, VAR.P.

pgc01

MrExcel MVP
Joined
Apr 25, 2006
Messages
19,840
Hi

You did not explain what you want, so this is a guess:

=IF(OR(E89={"Food Item Non-Taxable","Misc. Item Non-Taxable","Misc. Open Item Non-Taxable"}),0,G89*8.625%)
 

Watch MrExcel Video

Forum statistics

Threads
1,109,165
Messages
5,527,172
Members
409,750
Latest member
BorisYeltsin

This Week's Hot Topics

Top