User talk:Shrutika1993

Microsoft Excel Fomulas
Create or delete a formula

Formulas are equations that perform calculations on values in your worksheet. A formula starts with an equal sign (=). For example, the following formula multiplies 2 by 3 and then adds 5 to the result.

=5+2*3

A formula can also contain any or all of the following: functions (function: A prewritten formula that takes a value or values, performs an operation, and returns a value or values. Use functions to simplify and shorten formulas on a worksheet, especially those that perform lengthy or complex calculations.), references, operators (operator: A sign or symbol that specifies the type of calculation to perform within an expression. There are mathematical, comparison, logical, and reference operators.), and constants (constant: A value that is not calculated and, therefore, does not change. For example, the number 210, and the text "Quarterly Earnings" are constants. An expression, or a value resulting from an expression, is not a constant.).

=PI*A2^2

1 Functions: The PI function returns the value of pi: 3.142...

2 References: A2 returns the value in cell A2.

3 Constants: Numbers or text values entered directly into a formula, such as 2.

4 Operators: The ^ (caret) operator raises a number to a power, and the * (asterisk) operator multiplies.

'''What do you want to do? '''

1. Create a simple formula with constants and calculation operators 2. Create a formula with functions 3. Create a formula with nested functions 4. Create a formula with references and names 5. Create an array formula that calculates a single result 6. Create an array formula that calculates multiple results 7. Delete a formula 8. Learn tips and tricks about creating formulas 9. Avoid common errors when creating formulas

Create a simple formula with constants and calculation operators

The following formulas contain operators (operator: A sign or symbol that specifies the type of calculation to perform within an expression. There are mathematical, comparison, logical, and reference operators.) and constants (constant: A value that is not calculated and, therefore, does not change. For example, the number 210, and the text "Quarterly Earnings" are constants. An expression, or a value resulting from an expression, is not a constant.).

Example formula   What it does =128+345          Adds 128 and 345 =5^2              Squares 5

1.Click the cell in which you want to enter the formula. 2.Type = (an equal sign). 3.Enter the formula. 4.Press ENTER

Create a formula with functions

The following formulas contain functions (function: A prewritten formula that takes a value or values, performs an operation, and returns a value or values. Use functions to simplify and shorten formulas on a worksheet, especially those that perform lengthy or complex calculations.).

Example formula       What it does =SUM(A:A)             Adds all numbers in column A =AVERAGE(A1:B4)        Averages all numbers in the range

1.Click the cell in which you want to enter the formula.

2.To start the formula with the function, click Insert Function Button image on the formula bar (formula bar: A bar at the top of the Excel window that you use to enter or edit values or formulas in cells or charts. Displays the constant value or formula stored in the active cell.) Formula bar.

3.Select the function you want to use. You can enter a question that describes what you want to do in the Search for a function box (for example, "add numbers" returns the SUM function), or browse from the categories in the Or Select a category box.

4.Enter the arguments (argument: The values that a function uses to perform operations or calculations. The type of argument a function uses is specific to the function. Common arguments that are used within functions include numbers, text, cell references, and names.). To enter cell references as an argument, click Collapse Dialog Button image (which temporarily hides the dialog box), select the cells on the worksheet, and then press Expand Dialog Button image.

5.When you complete the formula, press ENTER