Thread: ifs and ors
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
garymme
 
Posts: n/a
Default 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....