Inputting text in a formula

[PGalla06]

I'm trying to write an if statement using VBA that returns text, however I can't seem to figure out how to get it to work as I need to include apostrophes in the if statement. Below is the code that I'm working with:

Range("V2").Formula = "=IF(" & "Q2" & ">0," & "Indemnity" & "," & "Medical" & ")"

Any help would be greatly appreciated.

Thanks,
Peter

[Bernie Deitrick]

Peter,

Range("V2").Formula = "=IF(Q2>0,""Indemnity"",""Medical"")"

HTH,
Bernie
MS Excel MVP


"PGalla06" <[email protected]> wrote in message
news:[email protected]...
>
> I'm trying to write an if statement using VBA that returns text, however
> I can't seem to figure out how to get it to work as I need to include
> apostrophes in the if statement. Below is the code that I'm working
> with:
>
> Range("V2").Formula = "=IF(" & "Q2" & ">0," & "Indemnity" & "," &
> "Medical" & ")"
>
> Any help would be greatly appreciated.
>
> Thanks,
> Peter
>
>
> --
> PGalla06
> ------------------------------------------------------------------------
> PGalla06's Profile: http://www.excelforum.com/member.php...o&userid=24260
> View this thread: http://www.excelforum.com/showthread...hreadid=398605
>