# How To Create Formulas In Microsoft Excel 2000

###### Tags:-office.com/ setup,office.com /setup , office.com/setup

Making equations

In school, you may have needed to retain certain equations to work math issues. Microsoft Excel utilizes recipes to perform counts inside a spreadsheet. In this exercise, you will figure out how to utilize Excel’s recipe highlights.

Subtraction

Multiplication                                                *

Division                                                             /

Exponentiation (to the power of)        ^

Priority (do this first)                (put in brackets)

Break even with to                                 =

Not equivalent to                                  < >

More prominent than                            >

Less than                                                     <

Creating a simple formula

How about we begin with a straightforward recipe that contains one numerical task. All equations start with the equivalents sign (=), regardless of whether the recipe comprises of including, subtracting, duplicating, or separating. Here’s a case of a straightforward recipe: =B2-B3.

To make a straightforward recipe utilizing the point-and-snap strategy:

• Enter the numbers you need to compute.
• Tap the cell where you need the outcome to show up.
• Sort the equivalents sign (=).
• Tap the primary cell to be incorporated into the equation.
• Sort a numerical administrator, (for example, the expansion image +). The administrator shows in the cell and in the Formula bar.
• Tap the following cell in the recipe.
• Rehash stages 4 and 5 until the point when the whole equation is entered.
• Press Enter or tap the Enter catch on the Formula bar. This progression closes the equation.
• Imperative pointIf you move to another cell, Excel will incorporate that cell in the equation.
• Tap the equivalents sign catch on the Formula bar as opposed to the equivalents sign on the console to open the Formula Palette, which gives you a chance to see the improvement of a recipe as you enter it.

blogs :  Office.com /setup