Videos tagged with functions

Mario sends in today's question. He has to do a SUMIF on a non-contiguous section of data. SUMIF can not handle this, but SUMPRODUCT can. Episode 886 shows you how.

Can you use a function in an Excel calculated field? Well, Bryony from the U.K. says yes you can, and sure enough...it works. Episode 878 shows an example of using a function to create a new field in a pivot cache. Fairly cool.

Interesting question from the Southeastern Accounting Show: I want to sum from cell A5 and sum down a certain number of cells. However, the number of cells is stored in cell C5! Episode 837 will show you the obscure but flexible OFFSET function that can solve this problem.

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.

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.

Learn how to use a simple English-language query in order to discover new functions. Episode 409 will show you how to find a function to calculate a monthly car payment. You can also use the Goal Seek function to immediately back into an answer.

Functions are small snippets of code that can process information, update databases, email friends, or print data to the screen. PHP comes out of the box with hundreds of great functions to begin with, but in this video we will make some of our own!