Functions are predefined formulas that perform calculations by using specific values, called arguments, in a particular order, or structure. Functions can be used to perform simple or …

How to use the IF function (combined with the AND, OR, and NOT functions) in Excel to make logical comparisons between given values.

To enter another function as an argument, enter the function in the argument box in the Formula Builder or directly into the cell. Enter any additional arguments that are needed to complete …

The IF function is one of the most popular functions in Excel, and it allows you to make logical comparisons between a value and what you expect. So an IF statement can have two results. …

Excel includes several built-in functions—RAND and NOW, for example—that don't use arguments. Following the Function statement, a function procedure includes one or more VBA …

Worksheet functions are categorized by their functionality. Click a category to browse its functions. Or press Ctrl+F to find a function by typing the first few letters or a descriptive word. …

How to use the SUM function in Excel to add individual values, cell references, ranges, or a mix of all three.

Master the art of Excel formulas with our comprehensive guide. Learn how to perform calculations, manipulate cell contents, and test conditions with ease.

How to create simple formulas in Excel using AutoSum and the SUM function, along with the add, subtract, multiply, or divide values in your worksheet.

How to use the SUMIFS function in Excel, one of Excel’s math and trig functions, to add arguments that meet multiple criteria.