vba - set cell to formula

[Weil]

Hi, I would llike to set a cell to a formula but am having a bit of difficulty.

here's my code:
Range("D33").Formula = "=IF(OR(C3="F 18-65", C3="M & F 18-65"),"35% 18-34, 35% 35-49, 30% 50-65", "see description below" ) "

I get a compile error, expected end of statement at the first F. I guess it's reading the quotes without regard to the paranthesis or functions contained within.

Does anyone have any thoughts about how to get this to work?

Thanks so much for your help!!

 

[texasalynn]

try this

Range("D33").Formula = _
        "=IF(OR(C3=""F 18-65"", C3=""M & F 18-65""),""35% 18-34, 35% 35-49, 30% 50-65"", ""see description below"" )"

 

[Aaron Blood]

A1 Format:
"=IF(OR(C3=""F 18-65"", C3=""M & F 18-65""),""35% 18-34, 35% 35-49, 30% 50-65"", ""see description below"" )"

R1C1 Format:
"=IF(OR(RC[-1]=""F 18-65"", RC[-1]=""M & F 18-65""),""35% 18-34, 35% 35-49, 30% 50-65"", ""see description below"" )"

 

[Weil]

ahh, I get it now, double quotes -

Thanks much!!