•1 min read•from 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?
[link] [comments]
Want to read more?
Check out the full article on the original site
Tagged with
#AI formula generation techniques
#formula generator
#financial modeling with spreadsheets
#rows.com
#Excel alternatives for data analysis
#Excel compatibility
#Excel alternatives
#natural language processing for spreadsheets
#generative AI for data analysis
#formulas
#SUMIF
#quotation marks
#CRITERIA
#original formula
#comment out
#N
#working formula
#edit
#try something different
#closure