{"id":626,"date":"2018-06-28T13:14:12","date_gmt":"2018-06-28T13:14:12","guid":{"rendered":"http:\/\/officetuts.net\/excel\/?p=626"},"modified":"2024-03-30T11:04:48","modified_gmt":"2024-03-30T11:04:48","slug":"formulas","status":"publish","type":"post","link":"https:\/\/officetuts.net\/excel\/training\/formulas\/","title":{"rendered":"Formulas in Excel"},"content":{"rendered":"\n
Formulas are expressions that perform calculations, manipulate data, or analyze information within a Microsoft Excel spreadsheet. They are used to automate tasks, perform complex calculations, and make data analysis more efficient.<\/p>\n\n\n\n
Entering a formula<\/h2>\n\n\n\n
If you enter the equal sign (=) at the beginning, Excel knows that it has to treat this entry as a formula and not as standard text or any other value.<\/p>\n\n\n\n
You can insert a formula into a cell in two ways: manually from the keyboard<\/strong> and through references to other cells<\/strong>.<\/p>\n\n\n\n
\n
You can also start by entering a formula using the plus (+) sign. Microsoft left this option for people that previously worked with the Lotus spreadsheet.<\/p>\nTIP<\/cite><\/blockquote>\n\n\n\n
If you start a formula with a plus, it will be automatically changed to the equal sign (=).<\/p>\n\n\n\n
Example 1:<\/strong><\/p>\n\n\n\n
Look at the following example. There are two cells with values: B2 = 2<\/strong> and B3 = 4<\/strong>. Enter the new formula to cell D2<\/strong> to sum up those two numbers. To enter this formula manually, type =B2+B3<\/strong>, and press Enter.<\/strong> It means: adding the values from cells: B2 and B3 and keeping the result in cell D2.<\/strong><\/p>\n\n\n\n