Learn Excel from Bill Jelen with this daily 2 minute video podcast.
Episode 769 looks at the difficult variations on yesterday's podcast; how do you set up an IF statement that will only be true if two conditions are true? This episode will look at using OR, AND, NOT within the logical test of the IF function.
posted by Bill at 9:00 AM
How do you deal with many levels in an IF statement? Episode 768 discusses nesting IF statements.
posted by Bill at 9:00 AM
A question asks how to avoid #VALUE errors when a formula refers to a cell with a blank text value. In Episode 767, I will take a look at how these blank cells come to be, how to work around the #VALUE error and even a different approach to prevent the root cause of the problem.
Labels: formulas, IF, ISBLANK, Number Format, Zeroes
posted by Bill at 9:00 AM
Jon asks how to calculate a winning or losing streak from baseball data. Episode 735 will show you how to build the formulas to calculate a win streak. Also, how to build a column showing Home or Away based on finding an @ sign in the opponent column.
posted by Bill at 9:00 AM
The PROPER function never manages to capitalize the interior C in McCartney. In today's podcast, an interesting way to solve this problem with a formula. Episode 722 shows you how.
posted by Bill at 9:00 AM
In today's podcast, we start with a data set where column A contains both Region and Model information. In Episode 702, I'll use formulas to split that data into two columns.
posted by Bill at 9:00 AM
