Excel Forum
Similar Content
Remove Vlookup #N/A Error in Excel
Tutorial: How to remove the #N/A error from Vlookup and replace it with a friendly message or a bl...
How to Find and Fix Errors in Complex Formulas in Excel
Tutorial: Here, I'll show you a quick, simple, and effective way to fix formulas and functions in E...
Count the Errors in a Range in Excel
Tutorial: How to count the number of errors in a range in Excel; also, how to count the occurrence ...



Highline Excel Class 25: Fix Problems & Errors In Spreadsheet


Learn about:
1.Nine errors & what they mean and how to fix them: ####, #NAME?, #N/A, #REF!, #VALUE!, #NUM!, #DIV/0!, Circular Reference, #NULL!
2.AVERAGE function will include zero in calculation, but not blanks
3.Go To Special Blanks
4.Ctrl Enter to add numbers to many cells instantly
5.SUM function will not add text, but the plus sign will
6.Convert number as text to numbers: 1) Text To Column or 2) Copy zero, Paste Special Operations Add

This is a beginning to advanced Excel class taught at Highline Community College by Mike Gel excelisfun Girvin Busn 214 BTech 109





Got a Question? Ask it Here in the Forum.