This article will explain how to use the conditional functions IF, AND, OR and NOT on Microsoft Excel. Each of these functions can be used as part of a formula in a cell to compare data samples in any ...

How to Graph a Function in Excel. A mathematical function is a formula that takes an input, x, applies a set of calculations to it, and produces an output called y.

Here are the types of IS functions you can choose from, and you can see some examples below: ISBLANK: Tests whether a is blank. ISOMITTED: Tests whether the value in a LAMBDA function is missing.

Revise how to recognise and determine the equation of a quadratic function from its graph. BBC Bitesize Scotland revision for SQA National 5 Maths.

Sketch derived, inverse or other related functions using graph translations. Complete the square and find composite functions for Higher Maths.

Excel has over 475 formulas in its Functions Library, but we've selected the most popular, from date and time functions to mathematics and simple data manipulation.