Super Easy Question -- "

K

kaon

Hi all,

I want to display "N/A" whenever the denominator is zero and I wrot
such code:

Cells(c, col).Formula = _
"=IF(" & Cells(c, j + 1).Address & "=0, "N/A", ("
Cells(c, j).Address & " - " & Cells(c, j + 1).Address & ") * 100 / "
Cells(c, j + 1).Address & ")"

However, I do not know how to tell Excel that some " are escap
character, anyone that can teach me?

Thanks
 
Top