Excel formula Pro

You can find the latest variety of excel formulas here

You can find the latest variety of excel formulas here

An overview of the formula in Excel

If you are new to Excel, you will soon realize that Excel is not just a grid to include numbers in columns or rows. Yes, Excel can not only be used to find the total of columns or rows of numbers, but can also be used to calculate mortgage payments, solve mathematical problems and techniques, or find the best troubleshooting based on the number of variables entered.

Excel does it using formulas in cells. The formula performs calculations or other actions on the data in the worksheet. The formula always starts with a sign equal to (=), which can be followed by numbers, mathematical operators (such as + or - for addition or subtraction), and the default Excel function to optimize the formula.

For example, the following formula multiplies 2 by 3 then adds 5 to the result of the multiplication to produce an answer, 11.

= 2 * 3 + 5

Here are some additional examples that you can include in the worksheet.

= A1 + A2 + A3 Adds values ​​in cells A1, A2, and A3.

= SUM (A1: A10) Use the SUM function to return the number of values ​​in A1 through A10.

= TODAY () Returns the current date.

= UPPER ("hello") Converts the text "hello" to "HELLO" using UPPER function.

= IF (A1> 0) Use the IF function to test cell A1 to determine if the cell contains a value greater than 0.

Part of the Excel formula

Using constants in the Excel formula

Using operator calculations in the Excel formula

Excel sequence in performing operations in the formula

Uses functions and functions that are stacked in Excel formulas

Using references in the Excel formula

Use names in Excel formulas

Using array formulas and array constants in Excel

Delete the formula

Avoid common mistakes when creating formulas

you can find all in this app