#### Related Topics:

Question about Microsoft Office Standard for PC

# Microsoft excel Why is it that it should always start in equal sign(=) or plus sign(+) in a formula in microsoft excel?

Posted by on

### Doug Klippert

• Level 1:

An expert who has achieved level 1.

• Contributor

Because otherwise Excel will interprate the entry as text.

Posted on Aug 31, 2007

×

my-video-file.mp4

×

## Related Questions:

### What are the formulas in grading the grades uisng microsoft excel

Formulas are used to specify calculations based on values in designated cells. Excel supports basic calculations as well as statistical, trigonometric and other specialized functions.

Formulas used in Excel must follow a certain syntax.

1. All formulas begin with an equals sign (=).
2. Some formulas use operands such as +,-, *,/ for addition, subtraction, multiplication or division.
For example, the formula =A1+A2+A3 would add the contents of cells A1, A2 and A3.
3. Other formulas refer to different functions such as SUM, AVERAGE and others.
For example, the formula =SUM(A1:A3) would add the contents for the range A1 through A3.
4. Formulas can be combined with operands.
For example, the formula =10*SUM(A1:A3) would add the contents cells A1 through A3 and multiply them by 10.
5. Functions can be nested within each other.
For example, the formula =SQRT(10*SUM(A1:A3)) would take the square root of ten times the sum of cells A1 through A3. When functions are nested, it is important that the number of left parentheses match the number of right parentheses.
tip

### Microsoft Shortcut keys for Microsoft Excel

Here's what you are looking for. Browse it and you can find it there all you want for shortcut keys. Follow this link below:

Microsoft Excel Shortcut keys
Enter data by using shortcut keysToPress

Complete a cell entryENTERCancel a cell entryESCRepeat the last actionF4 or CTRL+YStart a new line in the same cellALT+ENTERDelete the character to the left of the insertion point, or delete the selectionBACKSPACEDelete the character to the right of the insertion point, or delete the selectionDELETEDelete text to the end of the lineCTRL+DELETEMove one character up, down, left, or rightArrow keysMove to the beginning of the lineHOMEEdit a cell commentSHIFT+F2Create names from row and column labelsCTRL+SHIFT+F3Fill downCTRL+DFill to the rightCTRL+RFill the selected cell range with the current entryCTRL+ENTERComplete a cell entry and move down in the selectionENTERComplete a cell entry and move up in the selectionSHIFT+ENTERComplete a cell entry and move to the right in the selectionTABComplete a cell entry and move to the left in the selectionSHIFT+TABWork in cells or the formula bar by using shortcut keysToPressStart a formula= (EQUAL SIGN)Cancel an entry in the cell or formula barESCEdit the active cellF2Edit the active cell and then clear it, or delete the preceding character in the active cell as you edit the cell contentsBACKSPACEPaste a name into a formulaF3Define a nameCTRL+F3Calculate all sheets in all open workbooksF9 Calculate the active worksheetSHIFT+F9Insert the AutoSum formulaALT+= (EQUAL SIGN)Enter the dateCTRL+; (SEMICOLON)Enter the timeCTRL+SHIFT+: (COLON)Insert a hyperlinkCTRL+KComplete a cell entryENTERCopy the value from the cell above the active cell into the cell or the formula barCTRL+SHIFT+" (QUOTATION MARK)Alternate between displaying cell values and displaying cell formulasCTRL+` (SINGLE LEFT QUOTATION MARK)Copy a formula from the cell above the active cell into the cell or the formula barCTRL+' (APOSTROPHE)Enter a formula as an array formulaCTRL+SHIFT+ENTERDisplay the Formula Palette after you type a valid function name in a formulaCTRL+AInsert the argument names and parentheses for a function, after you type a valid function name in a formulaCTRL+SHIFT+ADisplay the AutoComplete listALT+DOWN ARROW
on Feb 11, 2011 • Computers & Internet

### Not able to scroll on my excel sheet

It's only in Excel you can't scroll? Can you scroll from side to side? If you have Excel 2003, try to press the "window" tab on the top and if the freeze pane is checked, uncheck it. Or if it says unfreeze pane, press that one. Hope this helps :)
Jul 20, 2009 • IBM ThinkPad T42 Notebook

### Need a formula in excel

use if statement
=IF(AND(OR(A1="clark",A1="skamania",A1="clickitat"),B1="WA"),1,0)
where A1=T2 and B1=U2

### Formula not working correctly

You need to change the =IF(AND to =IF(OR
Using AND is saying both conditions must be true. Using OR is saying either condition 1 or 2 need to be true

### I want to know how I can to apply the formula where the excell find one data and multiply for one data of other cell, what formula can I apply for my question?

Enter data the number 10 on cell A1. Enter data the number 20 on cell B2. Mouse click on cell C3. Press equal sign, press left arrow, press *, press left arrow twice, press enter. Mouse click on cell C3. You'll see your formula on the address bar. Hope this helps.

### Countifs

The formula in both versions is the same:

=countif(range,value)

i.e. The below formula will increase its count by one if any of the 18 cells it's checking are equal to 1.
=countif(A1:B9,1)

### Computer

Any formula in Excel starts with the equals sign ("="). This is how Excel distinguishes between formulas and literal values. Knowing this, you can create lots of formulas using the usual operators of +, -, * and / for addition, subtraction, multiplication and division, respectively. Please see the examples below.

Add the contents of cell A1 to the contents of cell B1: =A1+B1

Subtract 2 - 1: =2-1
Add the contents of cell A1 from the contents of cell B1: =B1-A1

Multiply 1 times 2: =1*2
Multiply the contents of cell A1 times the contents of cell B1: =A1*B1

I hope this resolves the question. If not, please let me know.

### Getting the excel formula

Suppose the value for \$ is stored in cell A3. Your formula would look like this: =(A3+A3*0.25)*1.5

The equals sign at the beginning of the formula is necessary. And if you want the result to be formatted as currency, you can do so by right-clicking the cell or column, format cell, number tab, choose currency.
Nov 15, 2007 • Computers & Internet

39 views

Level 3 Expert

Level 3 Expert