Excel Creating FormulasIn cell C5 enter the number 20, now in cell E5 type the formula: =C5+5 then press the Enter key. You will get the result. The formula says 5 is added to the value entered in the cell C5 as the value is 20 the result is 25. See the image: In a similar way other formulas can be created: =C2*5 for multiplication, the value in the cell C2 is multiplied with 5. =C2-5 for subtraction, 5 is subtracted from the value in the cell C2. More formulas can be created by typing = in the cell then selecting the appropriate values and typing correct mathematical symbol in between. See the formula created to calculate the distance in the image given below: See the formula created to calculate the phone bill in the image given below:
|
- Class 12
- Class 11
- Class 10
- Class 9
- Class 8
- Class 7
- Class 6
- CLASS (1-5)
- other
- Calculators
- All Calculators
- Calculators List
- Algebra Calculator
- Equation Solver
- Graphing Calculator
- Elimination Calculator – Solve System of Equations with
- Derivative Calculator
- Absolute Value Equation Calculator
- Adding Fractions Calculator
- Factoring Calculator
- Fraction Calculator
- Inequality Calculator
- Mixed Number Calculator
- Percentage Calculator
- Quadratic Equation Solver
- Quadratic Formula Calculator
- Scientific Notation Calculator
- Simplify Calculator
- System of Equations Calculator
- NCERT MCQs
- Tally
- Accounting in Hindi
- Ms Office
- Maths Important Questions
- Python Tutorial
- Calculators
- Class 12
- Class 11
- Class 10
- Class 9
- Class 8
- Class 7
- Class 6
- CLASS (1-5)
- other
- Calculators
- All Calculators
- Calculators List
- Algebra Calculator
- Equation Solver
- Graphing Calculator
- Elimination Calculator – Solve System of Equations with
- Derivative Calculator
- Absolute Value Equation Calculator
- Adding Fractions Calculator
- Factoring Calculator
- Fraction Calculator
- Inequality Calculator
- Mixed Number Calculator
- Percentage Calculator
- Quadratic Equation Solver
- Quadratic Formula Calculator
- Scientific Notation Calculator
- Simplify Calculator
- System of Equations Calculator
- NCERT MCQs
- Tally
- Accounting in Hindi
- Ms Office
- Maths Important Questions
- Python Tutorial
- Calculators