From the course: Excel 2016: Advanced Formulas and Functions

Unlock the full course today

Join today to access over 23,100 courses taught by industry experts.

Using ISBLANK, ISODD, ISEVEN, ISTEXT, ISNONTEXT, and ISNUMBER

Using ISBLANK, ISODD, ISEVEN, ISTEXT, ISNONTEXT, and ISNUMBER

From the course: Excel 2016: Advanced Formulas and Functions

Start my 1-month free trial Buy for my team

Using ISBLANK, ISODD, ISEVEN, ISTEXT, ISNONTEXT, and ISNUMBER

“

- Excel has a number of, what we might call, IS functions. That's not a formal name, but we see a function called ISTEXT, ISNUMBER, ISNONTEXT. There are a few others, too. Formulas tab in the ribbon, over to More Functions and Information functions. Quite a few in here, and we'll be using some of these in this movie. Once I had a list of numbers much longer than this and they were a lot smaller too, because I had zoomed back, and I realized I was having some problems with the total. I'm going to put a total up here, up top. I'll use Alt+=, that's a quick way of putting in auto sum, and then highlight the data here and press Enter. And I know that number is wrong. These about 10 cells here, surely they add up to more than 16,000 because they're all between 3,000 and 2,000. Something's off here, and you can probably see what's the problem. Is that a zero there? Is that an I? Is that a one next to it? Are there other ones around? We don't see any ones over here, do we? Well, I did that…

Contents