1 min readfrom Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community

For testing something else, how to comment out a formula that has several quotation marks? Would like to use N(""), but don't want to have to edit all my quotation marks.

I have a formula that works, but I want to try something different and don't want to lose the formulas because I know I will use them later. The formula is a SUMIF, with a bunch of if something equals "CRITERIA". So the original formula has quotation marks, and it looks like using N("") will close the first quotation mark with my starting quotation mark. Is there any way to just comment out my formula without losing or having to change my original formula?

submitted by /u/Trust_Issues2278
[link] [comments]

Want to read more?

Check out the full article on the original site

View original article