You can create a simple formula to add, subtract, multiply or divide values in your worksheet. Simple formulas always start with an equal sign (=), followed by constants that are numeric …

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

The workbook below shows examples simple formulas. You can change any of the existing formulas, or enter your own formulas to learn how they work and see their results.

Instead, Excel provides you with the ability to create custom functions, which are explained in this article. Tip: The information in this article is intended for advanced Excel users. For more …

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

Make cells display the formulas they contain, instead of the formula results. Protect cells so that formulas cannot be displayed or changed.

Create a simple formula to multiply and divide in an Excel spreadsheet. You can multiply two or more numbers in one cell or multiply and divide numbers using cell references.

Learn how to use the percentage formula in Excel to find the percentage of a total and the percentage of change between two numbers. Try it now!

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. …

Hide or display zero values in Excel worksheets by using an option in the Advanced tab, or by using a number format, using a conditional format, a function, and by hiding zeros in …