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

I found the solution. :

--
Message posted from http://www.ExcelForum.com