Videos tagged with if

Patrick has a tricky overtime calculation. Episode 910 will show how to calculate overtime for people who worked over 80 hours and to show a blank for people who worked less than 80 hours.

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.

How do you deal with many levels in an IF statement? Episode 768 discusses nesting IF statements.

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.

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.

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.

In this multi-part series we will build a small and simple guest book application. In this "encore" we will create a small admin page to approve pending comments. To do so, we will create a simple login script and a few functions.

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.

Conditional statements are some of the most used statements in PHP. Often times you want to display specific data based upon the type, or value of certain information. In this video we will cover commonly used statements like the if, if else, switch, etc.