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!!
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!!