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
--
Message posted from
http://www.ExcelForum.com