08033146625, 08092566265 Email: training@ictacademy.com.ng Log in   Register   IT Jobs   Tutorials   Gallery   Resources   About Us   Corporate Training


    Upcoming Classes   Project Management   CAD   Data Analysis   HSE   Web   All Courses   E-Learning   Contact Us  

Creating Formulas in Excel

If you set up a formula properly, it computes the correct answer when you enter it into a cell. You can set up a formula from the functions excel provides or create your own custom excel function. From then on, it keeps itself up to date, recalculating the results whenever you change any of the values that the formula uses.

Mathematical Operation Function
+ (plus sign) Addition
– (minus sign or hyphen) Subtraction
* (asterisk) Multiplication
For example, to create a formula in cell E4 that adds a value entered in cell C4 by a value in cell D4, enter the following formula in cell E4: =C4+D4

   

MORE TUTORIALS ON LATEST TECHNLOGIES


MySQL

JavaScript

.Net Framework

JSON