if and or statements 3

[CFNB]

Hello.

I would like to use OR in a IF statement.
The one I have right now is : =IF(A13="UNITED STATES ",A13,"")

what I would like to do is : =IF((A13="UNITED STATES " OR A13="JAPAN"),A13,"") but I get an error.

The search function is not working on this website.

Thanks.

 

[bluedragon2]

=IF(OR(A13="UNITED STATES ",A13="JAPAN"),A13,"")

[Blue]Blue[/Blue] [Dragon]

If I wasn't Blue, I would just be a Dragon...

 

[SkipVought]

Hi,

OR's and AND's are klunky in Excel, IMHO...
[tt]
=IF(OR(A13="UNITED STATES",A13="JAPAN"),A13,"")
[/tt]


Skip,

_[red][/red]

 

[yogia]

Hi CFNB:

You may also use ...

=IF(OR(A13={"UNITED STATES","JAPAN"}),A13,"")

Yogi Anand, D.Eng, P.E.
Energy Efficient Building Network LLC

http://www.energyefficientbuild.com

 

[CFNB]

thanks.