Using ISBLANK, ISODD, ISEVEN, ISTEXT, and ISNUMBER

- Excel has a number of functions that begin with IS.…I've listed a few of them right here in across row one.…If you're interested in more information on these,…you'll want to go to the formulas tab of the ribbon,…choose "Reference" and you'll find these under…"Information functions", and here's a whole…series of them here.…Now, we can use these in a variety of ways,…I consider using them mostly for error checking.…When you've got a huge list of numbers,…sometimes you're trying to tabulate information,…and you recognize you've got problems,…now if I put a sum of these numbers here…on top, I might not see a problem.…

Make this column a bit wider, and we'll type equal sum,…or we could just choose auto-sum here…and highlight the data this way.…Now if we reviewed the data, we'd probably…realize there's some problems.…If we put this in down below,…I'm going to click auto-sum here,…that's a dead giveaway that we've got a problem.…Excel looks upward for data…when you use the sum function,…if it doesn't see any numbers, it looks leftward.…