Super Easy Question -- "
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 |
Super Easy Question -- "
|
All times are GMT +1. The time now is 10:05 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com