Excel IF

Excel Advanced

Interview Questions

Excel Creating Formulas

In 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:

Please Share

Learn Latest Tutorials

Website Development Services

JavaTpoint (SSS IT Pvt Ltd) provides website development services in affordable cost. We develop websites on WordPress, Core PHP, CakePHP, CodeIgnitor, Open Cart, Servlet-JSP, Struts 2 and Spring technologies. Send us your requirement at hr@javatpoint.com. We will show you a free demo first, then we will proceed further.