ifs and ors

ifs and ors

Post by Z2FyeW1tZ » Fri, 05 May 2006 03:05:02


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....
 
 
 

ifs and ors

Post by Bob Philli » Fri, 05 May 2006 03:11:28

=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)



listed

 
 
 

ifs and ors

Post by Z2FyeW1tZ » Fri, 05 May 2006 21:55:02

Wow, thanks Bob, its exactly what I was trying to do!