ExcelBanter - ifs and ors

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - ifs and ors (https://www.excelbanter.com/excel-discussion-misc-queries/86595-ifs-ors.html)

garymme

ifs and ors

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

=IF(D2=OR("AB","NT","YT"),Y2*1.07,IF(D2=OR("BC","S K","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

ifs and ors

=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" wrote in message
...
can I not to this? it keeps giving me errors...

=IF(D2=OR("AB","NT","YT"),Y2*1.07,IF(D2=OR("BC","S K","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

ifs and ors

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" wrote in message
...
can I not to this? it keeps giving me errors...

=IF(D2=OR("AB","NT","YT"),Y2*1.07,IF(D2=OR("BC","S K","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....

All times are GMT +1. The time now is 11:12 AM.