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 [...]
I just love it when a student in one of my classes teaches me a new trick! Natalie Bhutto is my hero! I was teaching a class with PivotTables and the display was a wide-screen TV. I sized the window down so the PivotTable Field List would not be so far from the PivotTable when [...]
Click Here to Learn More and Sign Up for Dashboard Institute and create documents for your business that provide meaningful information in a user friendly format.
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”)