ifs and ors

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

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

"garymme" <[email protected]> wrote in message
news:[email protected]...
> 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....

[garymme]

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

"Bob Phillips" wrote:

> =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)
>
> "garymme" <[email protected]> wrote in message
> news:[email protected]...
> > 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....
>
>
>