What is formula/Function in excel?
In MS Excel formulas are pre-defined or custom function which are evaluated by
Excel application to give a value result.
How to apply formula in excel?
For apply formula on a cell you should write equal sign then write formula.
Because cell start with sign equal “=” will be evaluated by excel to give result value.
Ways to apply formula in MS Excel:-
There are three way to apply formula in excel:-
1. Discrete value formula:-
Example:- =6+7
2. Discrete cell address formula:-
Example;- “=A2*D3/A1”
3.Pre defined formulas(functions)
Example: - "=SUM(E1:E3)"
Important point to remember for apply formula:-
Suppose you want to apply formula then please remember BODMAS concept will be applied.
If you do not know BOADMAS then please read BOADMAS concept given below for given example.
BOADMAS example:-
“=(A2 * D2) / 2.”
Expressions( brackets) are evaluated first.
And then division evaluated.
And then Multiplication evaluated.
And in last addition and subtraction occurs.
In MS Excel formulas are pre-defined or custom function which are evaluated by
Excel application to give a value result.
How to apply formula in excel?
For apply formula on a cell you should write equal sign then write formula.
Because cell start with sign equal “=” will be evaluated by excel to give result value.
Ways to apply formula in MS Excel:-
There are three way to apply formula in excel:-
1. Discrete value formula:-
Example:- =6+7
2. Discrete cell address formula:-
Example;- “=A2*D3/A1”
3.Pre defined formulas(functions)
Example: - "=SUM(E1:E3)"
Important point to remember for apply formula:-
Suppose you want to apply formula then please remember BODMAS concept will be applied.
If you do not know BOADMAS then please read BOADMAS concept given below for given example.
BOADMAS example:-
“=(A2 * D2) / 2.”
Expressions( brackets) are evaluated first.
And then division evaluated.
And then Multiplication evaluated.
And in last addition and subtraction occurs.
No comments:
Post a Comment