ifs and ors

G

garymme

can I not to this? it keeps giving me errors...

=IF(D2=OR("AB","NT","YT"),Y2*1.07,IF(D2=OR("BC","SK","MB"),Y2*1.14))

I'm just trying to ask it to calculate something if it is one of the listed
codes, but I'm not sure I'm using my or statment right....
 
B

Bob Phillips

=IF(OR(D2={"AB","NT","YT"}),Y2*1.07,IF(OR(D2={"BC","SK","MB"}),Y2*1.14))



--
HTH

Bob Phillips

(remove xxx from email address if mailing direct)
 
Top