From the course: Excel Tips Weekly

Unlock this course with a free trial

Join today to access over 22,600 courses taught by industry experts.

Recognizing Excel Formula errors: #N/A, #VALUE!, #REF!, #DIV/0!, #NUM, and #NAME!

Recognizing Excel Formula errors: #N/A, #VALUE!, #REF!, #DIV/0!, #NUM, and #NAME! - Microsoft Excel Tutorial

From the course: Excel Tips Weekly

Start my 1-month free trial Buy for my team

Recognizing Excel Formula errors: #N/A, #VALUE!, #REF!, #DIV/0!, #NUM, and #NAME!

“

- [Instructor] When you work with formulas 2 in Excel, you're bound 3 to encounter errors at different times. 4 Many times the errors are obvious. 5 Maybe you refer to a wrong cell 6 or you mistype a formula name, that sort of thing. 7 In this worksheet, in the lower left corner, 8 in the green box, we see the different error types listed. 9 Notice how they all begin with that same symbol, 10 that symbol found on the number 3 key on most keyboards, 11 the hashtag pound sign number sign, 12 whatever you want to call it. 13 And they exist in so many different situations. 14 Many times as I suggested, you don't care what they are, 15 but there's a reason for each one of them. 16 We see the reasons there that show you some examples 17 of how these happen. 18 I'm working with some data over in column L. 19 I'm trying to find out which number appears most often. 20 I don't know if there is one or anything, 21 but there is…

Contents