INTRODUCTION TO FORMULAS:ARITHMETIC OPERATORS
A BRIEF INTRODUCTION TO FORMULAS WAS ALREADY GIVEN IN THE VERY FIRST POST What Excel does? How to use formula in Excel?
BUT NOW LET US MOVE FORWARD AND UNDERSTAND THE TERMINOLOGY, SYSTEM AND PROCEDURES WHICH WILL BE FOLLOWED IN FURTHER LEARNING
WHAT IS A FORMULA IN EXCEL?
A formula is a combination of digits and operators which return us a desired result after calculating that particular phrase.
Similar is the case of formula in Excel. If there were no FORMULAS in Excel, it would have been a simple word processing software like WORD.
FORMULA IN EXCEL can have mathematical operators, Excel functions and cell addresses or absolute values to process the calculations.
We will discuss each of them in details step wise step.
ARITHMETIC OPERATORS PERMITTED IN EXCEL
Following operators are permitted in Excel formula
ARITHMETIC OPERATORS: DESCRIPTION
Its one of the basic and widely used operators used in EXCEL FORMULAS. It adds the value of different operands.
Its one of the basic and widely used operators used in EXCEL FORMULAS. It SUBTRACTS the value of second operand from the first one.
Its one of the basic and widely used operators used in EXCEL FORMULAS. It DIVIDES the first operand from the second one and so on.
Its one of the basic and widely used operators used in EXCEL FORMULAS. It MULTIPLIES all the operands.
exponentiation(raising to the power)
It finds out the value when we raise the power of any number.
This operator attaches the text of one cell to the other. It is somewhat lesser know operator. Maximum people use the function directly even for the two values.
OTHER WAYS TO REACH THIS ARTICLE
HOW TO PUT FORMULA IN EXCEL, EXCEL BASICS, ARITHMETIC OPERATORS IN EXCEL, HOW TO ADD, SUBTRACT IN EXCEL, WHAT IS THE USE OF & IN EXCEL, HOW TO RAISE POWER IN EXCEL
YOU MAY LIKE
- What Excel does? How to use formula in Excel?
- USE OF FONTS, FONT SIZE, INDENTATION, TEXT TO THE RIGHT, TEXT TO THE LEFT, TEXT IN THE MIDDLE ETC.
- how to use name manager and how to define names in excel?
- FOR MORE ARTICLES, CLICK EXCEL OR TYPE IN SEARCH BELOW.