#NAME when creating formula

[meppwc]

I keep getting #NAME when I put a formula into a cell

I am trying to create the following logic:
If cell I2 or cell K2 is not blank, then populate with the value of C2, else, leave blank
Here is my attempt at the formula below
=IF(OR(I2<>"",K2<>""),C2,””)

Help Please

 

[Joe4]

Do you really have slanted double-quotes, like shown below:
=IF(OR(I2<>"",K2<>""),C2,””)

Excel does NOT like slanted quotes. Try replacing them with the ones you have earlier in the formula, and see if that resolves it:
=IF(OR(I2<>"",K2<>""),C2,"")

 

[Jonmo1]

It's the quotation marks..
Look closely at the formula in your post, the 3rd set of quotes appear to be slanted to the right a little bit.
The first 2 look good. I would remove and retype those quote marks.

 

[meppwc]

wow, had not noticed the slants.............corrected and worked..............thanks, I will be more observant next time

 

[Joe4]

wow, had not noticed the slants.............corrected and worked..............thanks, I will be more observant next time

Yes, most often times from data copied in from somewhere else (as opposed to direct typing).