OH, NO! I JUST DELETED A NAME THAT WAS USED IN A FORMULA
If you have used defined names in formulas and then delete that defined name, you will get an #NAME? error. Perhaps you should Find the name, as you defined it, looking in the entire workbook, BEFORE you delete the name. Then you are aware that you will have an issue. If you have pasted a [...]
Use the N function in Excel to Add a Comment to a Cell
You can add a “comment or note” to a cell with a formula and it will be hidden in the cell’s formula. The formula below multiplies the sales ($5,000) by 37.5% then there is a note that explains why. NOTE: +N(“quotations must be used around the note”)