MS Excel Formula Start With:
The formulae used for different calculations are referred to as Excel formulas. A mathematical component that defines a rule is known as a formula. It uses an equal sign to join one or more parts together. If one or more elements are known, the formula can be used to determine the element's value.
For example,
Sum = a + b
We can determine the value of b (b = Sum - a) if we know the values of a and sum. The sum can also be determined if we know the values of a and b (sum = a + b).
Or
Mean = Sum of all the observations/ Number of observations
The formulas mentioned above have three components. Knowing the value of any two elements will make determining the value of the third element simple.
Different formulas of MS Excel:
- SUM: = SUM(Cell 1:Cell 2).
- SUBTRACTION: =SUM(Cell 1, -Cell 2).
- MULTIPLICATION: =A3*B3.
- DIVISION: =C3/D3.
- LEFT: LEFT(text, Number_of_characters): =LEFT(B3,4).
- MID: MID(text, start position, Number_of_characters): =MID(B3,5,3).
- RIGHT: RIGHT(text, Number_of_characters): =RIGHT(B3,1).
- AVERAGE: =AVERAGE(C5:C9).
- COUNT: =COUNT(C3:C14).
- COUNTA: =COUNTA(B3:B15).
- MAX: =MAX(C3:C16).
- MIN: =MIN(C3:C16).
- TRIM =TRIM(B3).
- IF: =IF(D3>C3, 1, 0).
- PROPER: =PROPER(B3).
- RANDBETWEEN: =RANDBETWEEN(bottom, top).
- CONCATENATE: =CONCATENATE(B3, C3).
- EVEN: =EVEN(B3).
- ODD: =ODD(B3).
- TODAY: =TODAY().
☛ Related Questions
Comments
write a comment