Hopefully Simple Question with a Simple Explanation...PLEASE HELP!

[dassassin7]

Hi, I'm trying to nest an OR statement within an IF statement, with varying luck.

-----------

The following example works:

=IF(OR(H2="Apple",H2="ApplComputer",H2="APPLE CANADA DIV",H2="IPHONE",H2="MACBOOK"),"Apple”,"Other")

While the below example does not and instead returns a #NAME? error:

=IF(OR(H2="Sony",H2=“SONY Home ENTERTAINMENT DIV”),"Sony”,”Other”)

-----------

I'm really not seeing the reason for an error here because the structure and syntax used is consistent in both examples. Can't imagine caps/no caps combination has any impact...

Any help would be greatly appreciated!

Thanks,
D

 

[miless2111s]

Copying in your formula I had the same response. When I clicked into the formula the help text that came up didn't see that some elements of the If / then were "there". Typing it out worked. I narrowed it down to the Quote marks being different through the formula. If you use the straight sort (as in the h2="Sony" throughout the equation it works.
Hope that helps
Miles

 

[mcwillis81]

Hi, I'm trying to nest an OR statement within an IF statement, with varying luck.

-----------

The following example works:

=IF(OR(H2="Apple",H2="ApplComputer",H2="APPLE CANADA DIV",H2="IPHONE",H2="MACBOOK"),"Apple”,"Other")

While the below example does not and instead returns a #NAME? error:

=IF(OR(H2="Sony",H2=“SONY Home ENTERTAINMENT DIV”),"Sony”,”Other”)

-----------

I'm really not seeing the reason for an error here because the structure and syntax used is consistent in both examples. Can't imagine caps/no caps combination has any impact...

Any help would be greatly appreciated!

Thanks,
D

Hi,

I've had a quick look at this,

copy and pasting your Sony formula throws an error and i had to replace all the quotation marks " by deleting them and putting them back in. It then worked.

when i typed it manually from scratch it also worked fine.

Hope this helps.

 

[dassassin7]

Great, thank you both! Tried it again and works fine for me.

Appreciate the help!

Best,
D