| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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.... |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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.... |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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.... |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Linear Mode
