{"id":25556505,"date":"2023-03-16T22:36:28","date_gmt":"2023-03-16T17:06:28","guid":{"rendered":"https:\/\/entri.app\/blog\/?p=25556505"},"modified":"2025-08-26T14:48:09","modified_gmt":"2025-08-26T09:18:09","slug":"basic-excel-formulas-and-functions","status":"publish","type":"post","link":"https:\/\/entri.app\/blog\/basic-excel-formulas-and-functions\/","title":{"rendered":"Basic Excel Formulas and Functions with Examples"},"content":{"rendered":"<div id=\"ez-toc-container\" class=\"ez-toc-v2_0_79_2 counter-hierarchy ez-toc-counter ez-toc-custom ez-toc-container-direction\">\n<p class=\"ez-toc-title\" style=\"cursor:inherit\">Table of Contents<\/p>\n<label for=\"ez-toc-cssicon-toggle-item-69e635956edde\" class=\"ez-toc-cssicon-toggle-label\"><span class=\"\"><span class=\"eztoc-hide\" style=\"display:none;\">Toggle<\/span><span class=\"ez-toc-icon-toggle-span\"><svg style=\"fill: #999;color:#999\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" class=\"list-377408\" width=\"20px\" height=\"20px\" viewBox=\"0 0 24 24\" fill=\"none\"><path d=\"M6 6H4v2h2V6zm14 0H8v2h12V6zM4 11h2v2H4v-2zm16 0H8v2h12v-2zM4 16h2v2H4v-2zm16 0H8v2h12v-2z\" fill=\"currentColor\"><\/path><\/svg><svg style=\"fill: #999;color:#999\" class=\"arrow-unsorted-368013\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"10px\" height=\"10px\" viewBox=\"0 0 24 24\" version=\"1.2\" baseProfile=\"tiny\"><path d=\"M18.2 9.3l-6.2-6.3-6.2 6.3c-.2.2-.3.4-.3.7s.1.5.3.7c.2.2.4.3.7.3h11c.3 0 .5-.1.7-.3.2-.2.3-.5.3-.7s-.1-.5-.3-.7zM5.8 14.7l6.2 6.3 6.2-6.3c.2-.2.3-.5.3-.7s-.1-.5-.3-.7c-.2-.2-.4-.3-.7-.3h-11c-.3 0-.5.1-.7.3-.2.2-.3.5-.3.7s.1.5.3.7z\"\/><\/svg><\/span><\/span><\/label><input type=\"checkbox\"  id=\"ez-toc-cssicon-toggle-item-69e635956edde\"  aria-label=\"Toggle\" \/><nav><ul class='ez-toc-list ez-toc-list-level-1 ' ><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/entri.app\/blog\/basic-excel-formulas-and-functions\/#Introduction\" >Introduction<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/entri.app\/blog\/basic-excel-formulas-and-functions\/#What_are_Basic_Excel_Formulas_and_Functions\" >What are Basic Excel Formulas and Functions?<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/entri.app\/blog\/basic-excel-formulas-and-functions\/#Common_Functions\" >Common Functions<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-4\" href=\"https:\/\/entri.app\/blog\/basic-excel-formulas-and-functions\/#Numeric_Function\" >Numeric Function<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-5\" href=\"https:\/\/entri.app\/blog\/basic-excel-formulas-and-functions\/#String_Functions\" >String Functions<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-6\" href=\"https:\/\/entri.app\/blog\/basic-excel-formulas-and-functions\/#VLOOKUP_and_HLOOKUP_Functions\" >VLOOKUP and HLOOKUP Functions<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-7\" href=\"https:\/\/entri.app\/blog\/basic-excel-formulas-and-functions\/#Date_Time_Functions\" >Date Time Functions<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-8\" href=\"https:\/\/entri.app\/blog\/basic-excel-formulas-and-functions\/#Conclusion\" >Conclusion<\/a><\/li><\/ul><\/nav><\/div>\n<h2><span class=\"ez-toc-section\" id=\"Introduction\"><\/span><strong>Introduction<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>Microsoft Excel is the most preferred program for people who work in data-related careers like financial analysis, investment banking, data processing and financial modelling and presentation. It is very popular and one of the basics taught in computer classes.<\/p>\n<div class=\"lead-gen-block\"><a href=\"https:\/\/entri.app\/blog\/wp-content\/uploads\/2025\/07\/Excel-tutorial.pdf\" data-url=\"https:\/\/entri.app\/blog\/wp-content\/uploads\/2025\/07\/Excel-tutorial.pdf\" class=\"lead-pdf-download\" data-id=\"25556851\">\n<p style=\"text-align: center;\"><button class=\"btn btn-default\">excel tutorial- download PDF now!<\/button><\/p>\n<\/a><\/div>\n<p>Microsoft Excel is often considered to be the best industry standard piece of software when it comes to data analysis. It is equipped to generate reports and business insights and hence is widely used in the industry. It even has built-in applications that make it more user-friendly. Excel is the best when it comes to doing calculations solving math and engineering problems etc. Therefore, learning basic Excel formulas and functions and mastering them is a very important step for people who aim to attain high proficiency in financial analysis.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\" wp-image-25604787 aligncenter\" src=\"https:\/\/entri.app\/blog\/wp-content\/uploads\/2022\/01\/closeup-hands-using-computer-laptop-with-screen-showing-analysis-data-_1_-300x203.webp\" alt=\"ms excel\" width=\"470\" height=\"318\" srcset=\"https:\/\/entri.app\/blog\/wp-content\/uploads\/2022\/01\/closeup-hands-using-computer-laptop-with-screen-showing-analysis-data-_1_-300x203.webp 300w, https:\/\/entri.app\/blog\/wp-content\/uploads\/2022\/01\/closeup-hands-using-computer-laptop-with-screen-showing-analysis-data-_1_-1024x694.webp 1024w, https:\/\/entri.app\/blog\/wp-content\/uploads\/2022\/01\/closeup-hands-using-computer-laptop-with-screen-showing-analysis-data-_1_-768x520.webp 768w, https:\/\/entri.app\/blog\/wp-content\/uploads\/2022\/01\/closeup-hands-using-computer-laptop-with-screen-showing-analysis-data-_1_-1536x1041.webp 1536w, https:\/\/entri.app\/blog\/wp-content\/uploads\/2022\/01\/closeup-hands-using-computer-laptop-with-screen-showing-analysis-data-_1_-2048x1388.webp 2048w, https:\/\/entri.app\/blog\/wp-content\/uploads\/2022\/01\/closeup-hands-using-computer-laptop-with-screen-showing-analysis-data-_1_-150x102.webp 150w, https:\/\/entri.app\/blog\/wp-content\/uploads\/2022\/01\/closeup-hands-using-computer-laptop-with-screen-showing-analysis-data-_1_-750x508.webp 750w, https:\/\/entri.app\/blog\/wp-content\/uploads\/2022\/01\/closeup-hands-using-computer-laptop-with-screen-showing-analysis-data-_1_-1140x772.webp 1140w\" sizes=\"auto, (max-width: 470px) 100vw, 470px\" \/><\/p>\n<h2><span class=\"ez-toc-section\" id=\"What_are_Basic_Excel_Formulas_and_Functions\"><\/span><strong>What are Basic Excel Formulas and Functions?<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>Excel formulas are expressions which operate on values in a cell or over a range of cell addresses and operators. For example, the formula =A1+A2+A3 will give you the sum of values from cells A1, A2 and A3.<\/p>\n<p>Predefined formulas in Excel are known as functions. Using them, we can skip the tedious process of manually entering formulas by giving them user-friendly names. For example, the same formula in the above example can be expressed as the function =SUM (A1: A3). Just like in the example above, this function sums all the values from cell A1 to cell A3.<\/p>\n<div class=\"lead-gen-block\"><a href=\"https:\/\/entri.app\/blog\/wp-content\/uploads\/2025\/07\/Power-BI-tutorial-5.pdf\" data-url=\"https:\/\/entri.app\/blog\/wp-content\/uploads\/2025\/07\/Power-BI-tutorial-5.pdf\" class=\"lead-pdf-download\" data-id=\"25556851\">\n<p style=\"text-align: center;\"><button class=\"btn btn-default\">power bi tutorial &#8211; download PDF now!<\/button><\/p>\n<\/a><\/div>\n<p>There are many functions in excel that you can choose according to the operation you want to perform on the mentioned data set. Several basic Excel formulas and functions are listed by their categories below.<\/p>\n<p style=\"text-align: center;\"><a href=\"https:\/\/entri.app\/course\/data-science-and-machine-learning-course\/\" target=\"_blank\" rel=\"noopener\"><strong>Attend our data science and machine learning course for free &#8211; schedule a demo today!<\/strong><\/a><\/p>\n<h2><span class=\"ez-toc-section\" id=\"Common_Functions\"><\/span><strong>Common Functions<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>These are the most used among basic Excel formulas and functions.<\/p>\n<table width=\"608\">\n<thead>\n<tr>\n<td width=\"95\"><strong>Function<\/strong><\/td>\n<td width=\"231\"><strong>Explanation<\/strong><\/td>\n<td width=\"96\"><strong>Group<\/strong><\/td>\n<td width=\"176\"><strong>Examples <\/strong><\/td>\n<\/tr>\n<\/thead>\n<tbody>\n<tr>\n<td width=\"95\">SUM<\/td>\n<td width=\"231\">Perform addition on all the values in the mentioned range of cells<\/td>\n<td width=\"96\">Maths and Trigonometry<\/td>\n<td width=\"176\">=SUM(E1:E8)<\/td>\n<\/tr>\n<tr>\n<td width=\"95\">MIN<\/td>\n<td width=\"231\">Finds the smallest value in the mentioned range of cells<\/td>\n<td width=\"96\">Statistical<\/td>\n<td width=\"176\">=MIN(E1:E8)<\/td>\n<\/tr>\n<tr>\n<td width=\"95\">MAX<\/td>\n<td width=\"231\">Finds the highest value in the mentioned range of cells<\/td>\n<td width=\"96\">Statistical<\/td>\n<td width=\"176\">=MAX(E1:E8)<\/td>\n<\/tr>\n<tr>\n<td width=\"95\">AVERAGE<\/td>\n<td width=\"231\">Computes the average of the value in the mentioned range of cells<\/td>\n<td width=\"96\">Statistical<\/td>\n<td width=\"176\">=AVERAGE(E1:E8)<\/td>\n<\/tr>\n<tr>\n<td width=\"95\">COUNT<\/td>\n<td width=\"231\">Counts and return the number of cells in the mentioned range of cells<\/td>\n<td width=\"96\">Statistical<\/td>\n<td width=\"176\">=COUNT(E1:E8)<\/td>\n<\/tr>\n<tr>\n<td width=\"95\">LEN<\/td>\n<td width=\"231\">Finds and Returns the number of characters in a string text on which the function is performed<\/td>\n<td width=\"96\">Text<\/td>\n<td width=\"176\">=LEN(B7)<\/td>\n<\/tr>\n<tr>\n<td width=\"95\">SUMIF<\/td>\n<td width=\"231\">Perform addition on all the values in the mentioned range of cells that meet specific criteria.<\/p>\n<p>=SUMIF(range,criteria,[sum_range])<\/td>\n<td width=\"96\">Maths and \u00a0Trigonometry<\/td>\n<td width=\"176\">=SUMIF(D1:D8,\u201d&gt;=1000\u2033,C1:C8)<\/td>\n<\/tr>\n<tr>\n<td width=\"95\">AVERAGEIF<\/td>\n<td width=\"231\">Computes the average value in a range of cells that meet some specific criteria.<\/p>\n<p>=AVERAGEIF(range,criteria,[average_range])<\/td>\n<td width=\"96\">Statistical<\/td>\n<td width=\"176\">=AVERAGEIF(F1:F8,\u201dYes\u201d,E1:E8)<\/td>\n<\/tr>\n<tr>\n<td width=\"95\">DAYS<\/td>\n<td width=\"231\">Gives the number of days between two dates<\/td>\n<td width=\"96\">Date and Time<\/td>\n<td width=\"176\">=DAYS(D1,C1)<\/td>\n<\/tr>\n<tr>\n<td width=\"95\">NOW<\/td>\n<td width=\"231\">Gives the current system date and time<\/td>\n<td width=\"96\">Date and Time<\/td>\n<td width=\"176\">=NOW()<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p style=\"text-align: center;\"><a href=\"https:\/\/entri.app\/course\/data-science-and-machine-learning-course\/\" target=\"_blank\" rel=\"noopener\"><strong>Looking for a Data Science Career? Explore Here!<\/strong><\/a><\/p>\n<h2><span class=\"ez-toc-section\" id=\"Numeric_Function\"><\/span><strong>Numeric Function <\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>These are the Excel functions that are used to operate on numeric data.<\/p>\n<table>\n<thead>\n<tr>\n<td><strong>Function<\/strong><\/td>\n<td><strong>Explanation<\/strong><\/td>\n<td><strong>Group<\/strong><\/td>\n<td><strong>Example<\/strong><\/td>\n<\/tr>\n<\/thead>\n<tbody>\n<tr>\n<td>ISNUMBER<\/td>\n<td>Gives True if the mentioned value is numerical and False if it is not<\/td>\n<td>Information<\/td>\n<td>=ISNUMBER(A4)<\/td>\n<\/tr>\n<tr>\n<td>RAND<\/td>\n<td>Produces a random numeral between 0 and 1<\/td>\n<td>Maths and Trigonometry<\/td>\n<td>=RAND()<\/td>\n<\/tr>\n<tr>\n<td>ROUND<\/td>\n<td>Rounds off a decimal value to the mentioned number of decimal points<\/td>\n<td>Maths and Trigonometry<\/td>\n<td>=ROUND(3.34543,2)<\/td>\n<\/tr>\n<tr>\n<td>MEDIAN<\/td>\n<td>Gives the number in the middle of the set of mentioned numbers<\/td>\n<td>Statistical<\/td>\n<td>=MEDIAN(1,4,5,2,4)<\/td>\n<\/tr>\n<tr>\n<td>PI<\/td>\n<td>Gives the value of Maths Function PI(\u03c0)<\/td>\n<td>Maths and Trigonometry<\/td>\n<td>=PI()<\/td>\n<\/tr>\n<tr>\n<td>POWER<\/td>\n<td>Gives the result of a number raised to a power. POWER( number, power )<\/td>\n<td>Maths and Trigonometry<\/td>\n<td>=POWER(2,6)<\/td>\n<\/tr>\n<tr>\n<td>MOD<\/td>\n<td>Gives the remainder when you divide 2 numbers<\/td>\n<td>Maths and Trigonometry<\/td>\n<td>=MOD(10,2)<\/td>\n<\/tr>\n<tr>\n<td>ROMAN<\/td>\n<td>Transforms the mentioned number to roman numerals<\/td>\n<td>Maths and Trigonometry<\/td>\n<td>=ROMAN(19)<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p style=\"text-align: center;\"><a href=\"https:\/\/entri.app\/course\/data-science-and-machine-learning-course\/\" target=\"_blank\" rel=\"noopener\"><strong>Sign up to upgrade your data science skills!<\/strong><\/a><\/p>\n<h2><span class=\"ez-toc-section\" id=\"String_Functions\"><\/span><strong>String Functions<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>Basic Excel formulas and functions used to handle text data are called string functions. Some string functions are given below.<\/p>\n<table width=\"679\">\n<thead>\n<tr>\n<td width=\"73\"><strong>Function<\/strong><\/td>\n<td width=\"202\"><strong>Explanation<\/strong><\/td>\n<td><strong>Group<\/strong><\/td>\n<td><strong>Example <\/strong><\/td>\n<td><strong>Comment<\/strong><\/td>\n<\/tr>\n<\/thead>\n<tbody>\n<tr>\n<td width=\"73\">LEFT<\/td>\n<td width=\"202\">Gives a specific number of characters from the start (left-hand side) of mentioned string<\/td>\n<td>Text<\/td>\n<td>=LEFT(\u201cCATS85\u201d,4)<\/td>\n<td>Left 4 Characters of \u201cCATS85\u201d<\/td>\n<\/tr>\n<tr>\n<td width=\"73\">RIGHT<\/td>\n<td width=\"202\">Gives a specific number of characters from the end (right-hand side) of mentioned string<\/td>\n<td>Text<\/td>\n<td>=RIGHT(\u201cCATS85\u201d,2)<\/td>\n<td>Right 2 Characters of \u201cCATS85\u201d<\/td>\n<\/tr>\n<tr>\n<td width=\"73\">MID<\/td>\n<td width=\"202\">Recovers a number of characters from the middle of a string from a specific start position and length.<\/p>\n<p>=MID (text, start_num, num_chars)<\/td>\n<td>Text<\/td>\n<td>=MID(\u201cCATS85\u201d,2,3)<\/td>\n<td>Recovering Characters 2 to 5<\/td>\n<\/tr>\n<tr>\n<td width=\"73\">ISTEXT<\/td>\n<td width=\"202\">Gives True if the provided parameter is Text<\/td>\n<td>Information<\/td>\n<td>=ISTEXT(value)<\/td>\n<td>Value \u2013 The value to check.<\/td>\n<\/tr>\n<tr>\n<td width=\"73\">FIND<\/td>\n<td width=\"202\">Gives the beginning position of a mentioned text string within another text string. The find function is case-sensitive.<\/p>\n<p>=FIND(find_text, within_text, [start_num])<\/td>\n<td>Text<\/td>\n<td>=FIND(&#8220;oo&#8221;, &#8220;Roofing&#8221;,1)<\/td>\n<td>Find \u2018oo\u2019 in \u201cRoofing\u201d, gives the result 2<\/td>\n<\/tr>\n<tr>\n<td width=\"73\">REPLACE<\/td>\n<td width=\"202\">Substitutes part of a string with another specific string.<\/p>\n<p><strong>=<\/strong>REPLACE (old_text, start_num, num_chars, new_text)<\/td>\n<td>Text<\/td>\n<td>=REPLACE(&#8220;Roofing&#8221;,2,2, &#8220;ss\u201d)<\/td>\n<td>Replace \u201coo\u201d with \u201css\u201d<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p><img loading=\"lazy\" decoding=\"async\" class=\" wp-image-25604792 aligncenter\" src=\"https:\/\/entri.app\/blog\/wp-content\/uploads\/2024\/03\/man-is-working-computer-with-graph-screen-300x171.webp\" alt=\"data science\" width=\"467\" height=\"266\" srcset=\"https:\/\/entri.app\/blog\/wp-content\/uploads\/2024\/03\/man-is-working-computer-with-graph-screen-300x171.webp 300w, https:\/\/entri.app\/blog\/wp-content\/uploads\/2024\/03\/man-is-working-computer-with-graph-screen-1024x585.webp 1024w, https:\/\/entri.app\/blog\/wp-content\/uploads\/2024\/03\/man-is-working-computer-with-graph-screen-768x439.webp 768w, https:\/\/entri.app\/blog\/wp-content\/uploads\/2024\/03\/man-is-working-computer-with-graph-screen-1536x878.webp 1536w, https:\/\/entri.app\/blog\/wp-content\/uploads\/2024\/03\/man-is-working-computer-with-graph-screen-2048x1170.webp 2048w, https:\/\/entri.app\/blog\/wp-content\/uploads\/2024\/03\/man-is-working-computer-with-graph-screen-150x86.webp 150w, https:\/\/entri.app\/blog\/wp-content\/uploads\/2024\/03\/man-is-working-computer-with-graph-screen-750x429.webp 750w, https:\/\/entri.app\/blog\/wp-content\/uploads\/2024\/03\/man-is-working-computer-with-graph-screen-1140x651.webp 1140w\" sizes=\"auto, (max-width: 467px) 100vw, 467px\" \/><\/p>\n<h2><span class=\"ez-toc-section\" id=\"VLOOKUP_and_HLOOKUP_Functions\"><\/span><strong>VLOOKUP and HLOOKUP Functions<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>The purpose of the VLOOKUP function is to execute a vertical look-up in the leftmost column and then return a value in the same row from a column that you mention. The function HLOOKUP has the purpose of searching for a value in the top row of the table. It returns the value in the same column from a row you mention.<\/p>\n<div class=\"lead-gen-block\"><a href=\"https:\/\/entri.app\/blog\/wp-content\/uploads\/2023\/03\/data-science-1.pdf\" data-url=\"https:\/\/entri.app\/blog\/wp-content\/uploads\/2023\/03\/data-science-1.pdf\" class=\"lead-pdf-download\" data-id=\"25556851\">\n<p style=\"text-align: center;\"><button class=\"btn btn-default\">data science curriculum &#8211; download PDF now!<\/button><\/p>\n<\/a><\/div>\n<h2><span class=\"ez-toc-section\" id=\"Date_Time_Functions\"><\/span><strong>Date Time Functions<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>These are the basic excel function used for the manipulation of date values.<\/p>\n<table>\n<thead>\n<tr>\n<td><strong>Function<\/strong><\/td>\n<td><strong>Explanation<\/strong><\/td>\n<td><strong>Group<\/strong><\/td>\n<td><strong>Example <\/strong><\/td>\n<\/tr>\n<\/thead>\n<tbody>\n<tr>\n<td>DATE<\/td>\n<td>Gives the number that denotes the date in the excel code<\/td>\n<td>Date and Time<\/td>\n<td>=DATE(2023,2,4)<\/td>\n<\/tr>\n<tr>\n<td>DAYS<\/td>\n<td>Find the number of days between the given two dates<\/td>\n<td>Date and Time<\/td>\n<td>=DAYS(D4,C4)<\/td>\n<\/tr>\n<tr>\n<td>MONTH<\/td>\n<td>Gives the month from a date value<\/td>\n<td>Date and Time<\/td>\n<td>=MONTH(\u201c4\/2\/2023\u201d)<\/td>\n<\/tr>\n<tr>\n<td>MINUTE<\/td>\n<td>Gives the minutes from a time value<\/td>\n<td>Date and Time<\/td>\n<td>=MINUTE(\u201c12:31\u201d)<\/td>\n<\/tr>\n<tr>\n<td>YEAR<\/td>\n<td>Gives the year from a date value<\/td>\n<td>Date and Time<\/td>\n<td>=YEAR(\u201c04\/02\/2023\u201d)<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<h3><strong>10 basic Excel Formulas for Beginners<\/strong><\/h3>\n<div class=\"alert alert-warning\">\n<ol>\n<li><strong>SUM: Calculates the sum of a range of cells. Example: =SUM(A1:A10)<\/strong><\/li>\n<li><strong>AVERAGE: Calculates the average of a range of cells. Example: =AVERAGE(A1:A10)<\/strong><\/li>\n<li><strong>MAX: Returns the maximum value in a range of cells. Example: =MAX(A1:A10)<\/strong><\/li>\n<li><strong>MIN: Returns the minimum value in a range of cells. Example: =MIN(A1:A10)<\/strong><\/li>\n<li><strong>COUNT: Counts the number of cells in a range that contain a value. Example: =COUNT(A1:A10)<\/strong><\/li>\n<li><strong>IF: Returns one value if a condition is true and another value if it is false. Example: =IF(A1&gt;10, &#8220;Greater than 10&#8221;, &#8220;Less than or equal to 10&#8221;)<\/strong><\/li>\n<li><strong>VLOOKUP: Searches for a value in the first column of a table and returns a corresponding value in the same row from another column. Example: =VLOOKUP(A1, B1:C10, 2, FALSE)<\/strong><\/li>\n<li><strong>CONCATENATE: Combines two or more text strings into one. Example: =CONCATENATE(&#8220;John&#8221;, &#8221; &#8220;, &#8220;Doe&#8221;)<\/strong><\/li>\n<li><strong>LEFT: Returns a specified number of characters from the beginning of a text string. Example: =LEFT(A1, 5)<\/strong><\/li>\n<li><strong>RIGHT: Returns a specified number of characters from the end of a text string. Example: =RIGHT(A1, 5)<\/strong><\/li>\n<\/ol>\n<\/div>\n<div class=\"lead-gen-block\"><a href=\"https:\/\/entri.app\/blog\/wp-content\/uploads\/2025\/07\/SQL-cheat-sheet-Entri-Elevate.pdf\" data-url=\"https:\/\/entri.app\/blog\/wp-content\/uploads\/2025\/07\/SQL-cheat-sheet-Entri-Elevate.pdf\" class=\"lead-pdf-download\" data-id=\"25556851\">\n<p style=\"text-align: center;\"><button class=\"btn btn-default\">sql cheatsheet &#8211; download PDF now!<\/button><\/p>\n<\/a><\/div>\n<h3><strong>Steps to Avoid Mistakes while using Basic Excel Formulas and Functions<\/strong><\/h3>\n<ul>\n<li>Make sure the formula you entered is accurate according to BODMAS.<\/li>\n<li>Make sure the cell address is correct by pressing F2 and then crosschecking the cell address.<\/li>\n<li>The formula should always start with an equal sign. If not, you will get an error message.<\/li>\n<li>Make sure to switch the cell format to general before entering the function. Formulas will not work if text format is chosen.<\/li>\n<li>Space is counted as a character and hence you have to realise that a cell containing space is not the same as a blank cell.<\/li>\n<li>Text value should be provided inside double quotes [inverted comma] if we enter text value instead of the cell address.<\/li>\n<li>The numbers should not be enclosed in double-quotes.<\/li>\n<li>All opening and closing parenthesis should match.<\/li>\n<li>Copy the formula instead of retyping it.<\/li>\n<\/ul>\n<p>Excel is one of the best spreadsheet applications. In this article, we have discussed the basic Excel formulas and functions with examples. It will be more productive to use the above-listed functions instead of writing formulas. Functions also have high accuracy as the chances of making mistakes are low.<\/p>\n<p><a href=\"https:\/\/entri.app\/course\/data-science-course\/\"><img loading=\"lazy\" decoding=\"async\" class=\" wp-image-25621700 aligncenter\" src=\"https:\/\/entri.app\/blog\/wp-content\/uploads\/2023\/03\/data-science-1-scaler.webp\" alt=\"data science\" width=\"428\" height=\"356\" srcset=\"https:\/\/entri.app\/blog\/wp-content\/uploads\/2023\/03\/data-science-1-scaler.webp 300w, https:\/\/entri.app\/blog\/wp-content\/uploads\/2023\/03\/data-science-1-scaler-150x125.webp 150w\" sizes=\"auto, (max-width: 428px) 100vw, 428px\" \/><\/a><\/p>\n<h2 id=\"conclusion\" class=\"mb-2 mt-4 font-semimedium text-base first:mt-0 md:text-lg [hr+&amp;]:mt-4\"><span class=\"ez-toc-section\" id=\"Conclusion\"><\/span><strong>Conclusion<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p class=\"my-2 [&amp;+p]:mt-4 [&amp;_strong:has(+br)]:inline-block [&amp;_strong:has(+br)]:pb-2\">Microsoft Excel remains an indispensable tool for professionals in data-intensive fields like financial analysis, investment banking, and data science. Mastering basic Excel formulas and functions empowers you to perform complex calculations, generate insightful reports, and streamline data processing tasks efficiently. Whether you are a beginner or looking to sharpen your data skills, practicing these formulas is essential for career growth. To further enhance your data science and analytical expertise, consider enrolling in the\u00a0<a class=\"break-word hover:text-super hover:decoration-super underline decoration-from-font underline-offset-1 transition-all duration-300\" href=\"https:\/\/entri.app\/course\/data-science-course\/\" target=\"_blank\" rel=\"nofollow noopener\">Entri Data Science Course<\/a>\u00a0which offers comprehensive training and hands-on learning to take your skills to the next level.<\/p>\n<table>\n<tbody>\n<tr>\n<td colspan=\"2\" width=\"616\">\n<p style=\"text-align: center;\"><strong>Related links <\/strong><\/p>\n<\/td>\n<\/tr>\n<tr>\n<td width=\"308\"><strong><a href=\"https:\/\/entri.app\/blog\/benefits-of-big-data\/\" target=\"_blank\" rel=\"noopener\">Top 10 Benefits of Big Data<\/a><\/strong><\/td>\n<td width=\"308\"><strong><a href=\"https:\/\/entri.app\/blog\/top-50-data-analyst-interview-questions\/\" target=\"_blank\" rel=\"noopener\">Top 50 Data Analyst Interview Questions<\/a><\/strong><\/td>\n<\/tr>\n<tr>\n<td width=\"308\"><strong><a href=\"https:\/\/entri.app\/blog\/how-to-become-a-data-analyst\/\" target=\"_blank\" rel=\"noopener\">How to Become a Data Analyst? Skills Required<\/a><\/strong><\/td>\n<td width=\"308\"><strong><a href=\"https:\/\/entri.app\/blog\/best-data-visualization-tools-list\/\" target=\"_blank\" rel=\"noopener\">Explore Best Data Visualization Tools List<\/a><\/strong><\/td>\n<\/tr>\n<tr>\n<td width=\"308\"><strong><a href=\"https:\/\/entri.app\/blog\/principal-component-analysis-in-machine-learning\/\" target=\"_blank\" rel=\"noopener\">Principal Component Analysis in Machine Learning<\/a><\/strong><\/td>\n<td width=\"308\"><strong><a href=\"https:\/\/entri.app\/blog\/data-engineer-roles\/\" target=\"_blank\" rel=\"noopener\">Data Engineer &#8211; Roles, Responsibilities and Skills Required<\/a><\/strong><\/td>\n<\/tr>\n<tr>\n<td width=\"308\"><strong><a href=\"https:\/\/entri.app\/blog\/data-wrangling-vs-data-cleaning-know-the-difference\/\" target=\"_blank\" rel=\"noopener\">Data Wrangling vs Data Cleaning &#8211; Know the Difference<\/a><\/strong><\/td>\n<td width=\"308\"><strong><a href=\"https:\/\/entri.app\/blog\/confusion-matrix-in-machine-learning\/\" target=\"_blank\" rel=\"noopener\">Confusion Matrix in Machine Learning<\/a><\/strong><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<div class=\"modal\" id=\"modal25556851\"><div class=\"modal-content\"><span class=\"close-button\">&times;<\/span>\n\n<div class=\"wpcf7 no-js\" id=\"wpcf7-f25556851-o1\" lang=\"en-US\" dir=\"ltr\" data-wpcf7-id=\"25556851\">\n<div class=\"screen-reader-response\"><p role=\"status\" aria-live=\"polite\" aria-atomic=\"true\"><\/p> <ul><\/ul><\/div>\n<form action=\"\/blog\/wp-json\/wp\/v2\/posts\/25556505#wpcf7-f25556851-o1\" method=\"post\" class=\"wpcf7-form init\" aria-label=\"Contact form\" novalidate=\"novalidate\" data-status=\"init\">\n<fieldset class=\"hidden-fields-container\"><input type=\"hidden\" name=\"_wpcf7\" value=\"25556851\" \/><input type=\"hidden\" name=\"_wpcf7_version\" value=\"6.1.4\" \/><input type=\"hidden\" name=\"_wpcf7_locale\" value=\"en_US\" \/><input type=\"hidden\" name=\"_wpcf7_unit_tag\" value=\"wpcf7-f25556851-o1\" \/><input type=\"hidden\" name=\"_wpcf7_container_post\" value=\"0\" \/><input type=\"hidden\" name=\"_wpcf7_posted_data_hash\" value=\"\" \/><input type=\"hidden\" name=\"_wpcf7cf_hidden_group_fields\" value=\"[]\" \/><input type=\"hidden\" name=\"_wpcf7cf_hidden_groups\" value=\"[]\" \/><input type=\"hidden\" name=\"_wpcf7cf_visible_groups\" value=\"[]\" \/><input type=\"hidden\" name=\"_wpcf7cf_repeaters\" value=\"[]\" \/><input type=\"hidden\" name=\"_wpcf7cf_steps\" value=\"{}\" \/><input type=\"hidden\" name=\"_wpcf7cf_options\" value=\"{&quot;form_id&quot;:25556851,&quot;conditions&quot;:[],&quot;settings&quot;:{&quot;animation&quot;:&quot;yes&quot;,&quot;animation_intime&quot;:200,&quot;animation_outtime&quot;:200,&quot;conditions_ui&quot;:&quot;normal&quot;,&quot;notice_dismissed&quot;:false,&quot;notice_dismissed_update-cf7-5.9.8&quot;:true,&quot;notice_dismissed_update-cf7-6.1.1&quot;:true}}\" \/>\n<\/fieldset>\n<p><span class=\"wpcf7-form-control-wrap\" data-name=\"full_name\"><input size=\"40\" maxlength=\"400\" class=\"wpcf7-form-control wpcf7-text wpcf7-validates-as-required\" aria-required=\"true\" aria-invalid=\"false\" placeholder=\"Name\" value=\"\" type=\"text\" name=\"full_name\" \/><\/span><br \/>\n<span class=\"wpcf7-form-control-wrap\" data-name=\"phone\"><input size=\"40\" maxlength=\"400\" class=\"wpcf7-form-control wpcf7-tel wpcf7-validates-as-required wpcf7-text wpcf7-validates-as-tel\" aria-required=\"true\" aria-invalid=\"false\" placeholder=\"Phone\" value=\"\" type=\"tel\" name=\"phone\" \/><\/span><br \/>\n<span class=\"wpcf7-form-control-wrap\" data-name=\"email_id\"><input size=\"40\" maxlength=\"400\" class=\"wpcf7-form-control wpcf7-email wpcf7-text wpcf7-validates-as-email\" aria-invalid=\"false\" placeholder=\"Email\" value=\"\" type=\"email\" name=\"email_id\" \/><\/span>\n<\/p>\n<div class=\"custom-form-group-1\">\n\t<p><span class=\"wpcf7-form-control-wrap\" data-name=\"language\"><select class=\"wpcf7-form-control wpcf7-select wpcf7-validates-as-required language-select1\" aria-required=\"true\" aria-invalid=\"false\" name=\"language\"><option value=\"\">Select Language<\/option><option value=\"Malayalam\">Malayalam<\/option><option value=\"Tamil\">Tamil<\/option><option value=\"Telugu\">Telugu<\/option><option value=\"Kannada\">Kannada<\/option><\/select><\/span>\n\t<\/p>\n<\/div>\n<div class=\"custom-form-group-1\">\n\t<p><span class=\"wpcf7-form-control-wrap\" data-name=\"course\"><select class=\"wpcf7-form-control wpcf7-select wpcf7-validates-as-required course-select1\" aria-required=\"true\" aria-invalid=\"false\" name=\"course\"><option value=\"\">Select an option<\/option><option value=\"Kerala PSC Exams\">Kerala PSC Exams<\/option><option value=\"Kerala PSC Teaching Exams\">Kerala PSC Teaching Exams<\/option><option value=\"Kerala PSC Technical Exams\">Kerala PSC Technical Exams<\/option><option value=\"SSC\/RRB\">SSC\/RRB<\/option><option value=\"GATE\">GATE<\/option><option value=\"Banking &amp; Insurance\">Banking &amp; Insurance<\/option><option value=\"Coding\">Coding<\/option><option value=\"Commerce\">Commerce<\/option><option value=\"Personal Finance\">Personal Finance<\/option><option value=\"Spoken English\/Personality Dev\">Spoken English\/Personality Dev<\/option><option value=\"German Language\">German Language<\/option><option value=\"Montessori Teacher Training\">Montessori Teacher Training<\/option><option value=\"IELTS\">IELTS<\/option><option value=\"MEP\">MEP<\/option><option value=\"Quantity Surveying\">Quantity Surveying<\/option><option value=\"Structural Design\">Structural Design<\/option><option value=\"Yoga TTC\">Yoga TTC<\/option><option value=\"Digital Marketing\">Digital Marketing<\/option><option value=\"Hospital and Healthcare Administration\">Hospital and Healthcare Administration<\/option><option value=\"BIM\">BIM<\/option><option value=\"HR Management\">HR Management<\/option><option value=\"Embedded System Software Engineering\">Embedded System Software Engineering<\/option><\/select><\/span>\n\t<\/p>\n<\/div>\n<div class=\"custom-form-group-1\">\n\t<p><span class=\"wpcf7-form-control-wrap\" data-name=\"course_name\"><select class=\"wpcf7-form-control wpcf7-select wpcf7-validates-as-required course-name-select1\" aria-required=\"true\" aria-invalid=\"false\" name=\"course_name\"><option value=\"\">Select an option<\/option><option value=\"KAS\">KAS<\/option><option value=\"Degree level\">Degree level<\/option><option value=\"12th level\">12th level<\/option><option value=\"10th level\">10th level<\/option><option value=\"Secretariat Assistant\">Secretariat Assistant<\/option><option value=\"LDC\">LDC<\/option><option value=\"LGS\">LGS<\/option><option value=\"University Assistant\">University Assistant<\/option><option value=\"FSO\">FSO<\/option><option value=\"VEO\">VEO<\/option><option value=\"VFA\">VFA<\/option><option value=\"Dental Surgeon\">Dental Surgeon<\/option><option value=\"Staff Nurse\">Staff Nurse<\/option><option value=\"Sub Inspector\">Sub Inspector<\/option><option value=\"Divisional Accountant\">Divisional Accountant<\/option><option value=\"Fireman\/Firewomen\/Driver\">Fireman\/Firewomen\/Driver<\/option><option value=\"CPO\/WCPO\/Driver\">CPO\/WCPO\/Driver<\/option><option value=\"Excise\">Excise<\/option><option value=\"LD Typist\">LD Typist<\/option><option value=\"Junior Health Inspector\">Junior Health Inspector<\/option><option value=\"Assistant Jailor\">Assistant Jailor<\/option><option value=\"Kerala High Court Assistant\">Kerala High Court Assistant<\/option><option value=\"Beat Forest Officer\">Beat Forest Officer<\/option><option value=\"Junior Employment Officer\">Junior Employment Officer<\/option><option value=\"Junior Lab Assistant\">Junior Lab Assistant<\/option><option value=\"Dewaswom Board LDC\">Dewaswom Board LDC<\/option><option value=\"LSGS\">LSGS<\/option><option value=\"SBCID\">SBCID<\/option><option value=\"IRB Regular wing\">IRB Regular wing<\/option><option value=\"Assistant Salesman\">Assistant Salesman<\/option><option value=\"Secretariat OA\">Secretariat OA<\/option><option value=\"Driver Cum OA\">Driver Cum OA<\/option><option value=\"Departmental Test\">Departmental Test<\/option><option value=\"HSST\">HSST<\/option><option value=\"HSA\">HSA<\/option><option value=\"SET\">SET<\/option><option value=\"KTET\">KTET<\/option><option value=\"LP UP\">LP UP<\/option><option value=\"KVS\">KVS<\/option><option value=\"Finger Print Searcher\">Finger Print Searcher<\/option><option value=\"Nursery School Teacher\">Nursery School Teacher<\/option><option value=\"Railway Teacher\">Railway Teacher<\/option><option value=\"Scientific Officer\">Scientific Officer<\/option><option value=\"Probation Officer\">Probation Officer<\/option><option value=\"ICDS\">ICDS<\/option><option value=\"Welfare Officer Gr. II\">Welfare Officer Gr. II<\/option><option value=\"Assistant Professor\">Assistant Professor<\/option><option value=\"CTET\">CTET<\/option><option value=\"UGC NET\">UGC NET<\/option><option value=\"Sanitary Chemist\">Sanitary Chemist<\/option><option value=\"AE\">AE<\/option><option value=\"IEO\">IEO<\/option><option value=\"Electrician\">Electrician<\/option><option value=\"KSEB AE\/Sub Engineer\">KSEB AE\/Sub Engineer<\/option><option value=\"Kerala Agro Industries AE\">Kerala Agro Industries AE<\/option><option value=\"Overseer\/Draftsman\">Overseer\/Draftsman<\/option><option value=\"Lecturer in Polytechnic\">Lecturer in Polytechnic<\/option><option value=\"LSGD AE\">LSGD AE<\/option><option value=\"Devaswom Work Superintendent\">Devaswom Work Superintendent<\/option><option value=\"Devaswom Board Lineman\">Devaswom Board Lineman<\/option><option value=\"Devaswom Board Plumber\">Devaswom Board Plumber<\/option><option value=\"Assistant Town Planner\">Assistant Town Planner<\/option><option value=\"AAI ATC\">AAI ATC<\/option><option value=\"Central Govt PSU\">Central Govt PSU<\/option><option value=\"RRB ALP\">RRB ALP<\/option><option value=\"RRB JE\">RRB JE<\/option><option value=\"GATE\">GATE<\/option><option value=\"Skilled Assistant\">Skilled Assistant<\/option><option value=\"Workshop Instructor\">Workshop Instructor<\/option><option value=\"AMVI\">AMVI<\/option><option value=\"Technician gr 1\">Technician gr 1<\/option><option value=\"Technician gr 3\">Technician gr 3<\/option><option value=\"Assistant Professor - Tech\">Assistant Professor - Tech<\/option><option value=\"KSEB Worker\">KSEB Worker<\/option><option value=\"SSC CGL\">SSC CGL<\/option><option value=\"SSC CHSL\">SSC CHSL<\/option><option value=\"SSC CPO\">SSC CPO<\/option><option value=\"SSC MTS\">SSC MTS<\/option><option value=\"SSC GD Constable\">SSC GD Constable<\/option><option value=\"SSC JE\">SSC JE<\/option><option value=\"SSC Stenographer\">SSC Stenographer<\/option><option value=\"SSC JHT\">SSC JHT<\/option><option value=\"SSC Selection Post\">SSC Selection Post<\/option><option value=\"SSC Scientific Assistant IMD\">SSC Scientific Assistant IMD<\/option><option value=\"SSC Phase IX\/XI Selection Posts\">SSC Phase IX\/XI Selection Posts<\/option><option value=\"RRB NTPC\">RRB NTPC<\/option><option value=\"RRB Group D\">RRB Group D<\/option><option value=\"RRB Paramedical\">RRB Paramedical<\/option><option value=\"RRB Ministerial and Isolated Categories\">RRB Ministerial and Isolated Categories<\/option><option value=\"RRB RPF\">RRB RPF<\/option><option value=\"IBPS PO\">IBPS PO<\/option><option value=\"IBPS Clerk\">IBPS Clerk<\/option><option value=\"IBPS SO\">IBPS SO<\/option><option value=\"IBPS RRB PO\">IBPS RRB PO<\/option><option value=\"IBPS RRB Clerk\">IBPS RRB Clerk<\/option><option value=\"SBI PO\">SBI PO<\/option><option value=\"SBI Clerk\">SBI Clerk<\/option><option value=\"SBI SO\">SBI SO<\/option><option value=\"RBI Grade B\">RBI Grade B<\/option><option value=\"RBI Assistant\">RBI Assistant<\/option><option value=\"NABARD Grade A\">NABARD Grade A<\/option><option value=\"NABARD Grade B\">NABARD Grade B<\/option><option value=\"SIDBI Grade A\">SIDBI Grade A<\/option><option value=\"Insurance Exams\">Insurance Exams<\/option><option value=\"Federal Bank Exams\">Federal Bank Exams<\/option><option value=\"Union Bank of India Exams\">Union Bank of India Exams<\/option><option value=\"Full Stack Development Course\">Full Stack Development Course<\/option><option value=\"Data Science Course\">Data Science Course<\/option><option value=\"Data Analytics Course\">Data Analytics Course<\/option><option value=\"Software Testing Course\">Software Testing Course<\/option><option value=\"Python Programming Course\">Python Programming Course<\/option><option value=\"UI\/UX\">UI\/UX<\/option><option value=\"AWS Course\">AWS Course<\/option><option value=\"Flutter\">Flutter<\/option><option value=\"Cybersecurity\">Cybersecurity<\/option><option value=\"Practical Accounting Course\">Practical Accounting Course<\/option><option value=\"SAP FICO Course\">SAP FICO Course<\/option><option value=\"SAP MM Course\">SAP MM Course<\/option><option value=\"SAP SD Course\">SAP SD Course<\/option><option value=\"PwC Edge: Strategic Accounting &amp; Finance Programme\">PwC Edge: Strategic Accounting &amp; Finance Programme<\/option><option value=\"ACCA\">ACCA<\/option><option value=\"Tally\">Tally<\/option><option value=\"UAE Accounting\">UAE Accounting<\/option><option value=\"GST\">GST<\/option><option value=\"Stock Market Course\">Stock Market Course<\/option><option value=\"Mutual Funds\">Mutual Funds<\/option><option value=\"Forex Trading\">Forex Trading<\/option><option value=\"Kerala PSC Exams\">Kerala PSC Exams<\/option><option value=\"Kerala PSC Teaching Exams\">Kerala PSC Teaching Exams<\/option><option value=\"Kerala PSC Technical Exams\">Kerala PSC Technical Exams<\/option><option value=\"SSC\/RRB\">SSC\/RRB<\/option><option value=\"GATE\">GATE<\/option><option value=\"Banking &amp; Insurance\">Banking &amp; Insurance<\/option><option value=\"Coding\">Coding<\/option><option value=\"Commerce\">Commerce<\/option><option value=\"Personal Finance\">Personal Finance<\/option><option value=\"Spoken English\/Personality Dev\">Spoken English\/Personality Dev<\/option><option value=\"German Language\">German Language<\/option><option value=\"Montessori Teacher Training\">Montessori Teacher Training<\/option><option value=\"IELTS\">IELTS<\/option><option value=\"MEP\">MEP<\/option><option value=\"Quantity Surveying\">Quantity Surveying<\/option><option value=\"Structural Design\">Structural Design<\/option><option value=\"Yoga TTC\">Yoga TTC<\/option><option value=\"Digital Marketing\">Digital Marketing<\/option><option value=\"Hospital and Healthcare Administration\">Hospital and Healthcare Administration<\/option><option value=\"BIM\">BIM<\/option><option value=\"HR Management\">HR Management<\/option><option value=\"Embedded System Software Engineering\">Embedded System Software Engineering<\/option><\/select><\/span>\n\t<\/p>\n<\/div>\n<p><span class=\"wpcf7-form-control-wrap\" data-name=\"education\"><input size=\"40\" maxlength=\"400\" class=\"wpcf7-form-control wpcf7-text wpcf7-validates-as-required\" aria-required=\"true\" aria-invalid=\"false\" placeholder=\"Educational qualification\" value=\"\" type=\"text\" name=\"education\" \/><\/span>\n<\/p>\n<div style=\"display:none\">\n<input class=\"wpcf7-form-control wpcf7-hidden utm-source\" value=\"\" type=\"hidden\" name=\"utm_source\" \/>\n<input class=\"wpcf7-form-control wpcf7-hidden utm-medium\" value=\"\" type=\"hidden\" name=\"utm_medium\" \/>\n<input class=\"wpcf7-form-control wpcf7-hidden utm-campaign\" value=\"\" type=\"hidden\" name=\"utm_campaign\" \/>\n<input class=\"wpcf7-form-control wpcf7-hidden utm-content\" value=\"\" type=\"hidden\" name=\"utm_content\" \/>\n<input class=\"wpcf7-form-control wpcf7-hidden utm-term\" value=\"\" type=\"hidden\" name=\"utm_term\" \/>\n<input class=\"wpcf7-form-control wpcf7-hidden blog-url\" value=\"\" type=\"hidden\" name=\"blog_url\" \/>\n<input class=\"wpcf7-form-control wpcf7-hidden post-category-name\" value=\"\" type=\"hidden\" name=\"post_category_name\" \/>\n<input class=\"wpcf7-form-control wpcf7-hidden post-author-name\" value=\"\" type=\"hidden\" name=\"post_author_name\" \/>\n<input class=\"wpcf7-form-control wpcf7-hidden file-url\" value=\"\" type=\"hidden\" name=\"file_url\" \/>\n<input class=\"wpcf7-form-control wpcf7-hidden video-url\" value=\"\" type=\"hidden\" name=\"video_url\" \/>\n<input class=\"wpcf7-form-control wpcf7-hidden courseid\" value=\"\" type=\"hidden\" name=\"course_id\" \/>\n<\/div>\n<div class=\"cf7-cf-turnstile\" style=\"margin-top: 0px; margin-bottom: -15px;\"> <div id=\"cf-turnstile-cf7-4251265820\" class=\"cf-turnstile\" data-sitekey=\"0x4AAAAAABVigxtkiZeGTu5L\" data-theme=\"light\" data-language=\"auto\" data-size=\"normal\" data-retry=\"auto\" data-retry-interval=\"1000\" data-action=\"contact-form-7\" data-appearance=\"always\"><\/div> <script>document.addEventListener(\"DOMContentLoaded\", function() { setTimeout(function(){ var e=document.getElementById(\"cf-turnstile-cf7-4251265820\"); e&&!e.innerHTML.trim()&&(turnstile.remove(\"#cf-turnstile-cf7-4251265820\"), turnstile.render(\"#cf-turnstile-cf7-4251265820\", {sitekey:\"0x4AAAAAABVigxtkiZeGTu5L\"})); }, 0); });<\/script> <br class=\"cf-turnstile-br cf-turnstile-br-cf7-4251265820\"> <style>#cf-turnstile-cf7-4251265820 { margin-left: -15px; }<\/style> <script>document.addEventListener(\"DOMContentLoaded\",function(){document.querySelectorAll('.wpcf7-form').forEach(function(e){e.addEventListener('submit',function(){if(document.getElementById('cf-turnstile-cf7-4251265820')){setTimeout(function(){turnstile.reset('#cf-turnstile-cf7-4251265820');},1000)}})})});<\/script> <\/div><br\/><input class=\"wpcf7-form-control wpcf7-submit has-spinner\" type=\"submit\" value=\"Submit\" \/>\n<\/p><div class=\"wpcf7-response-output\" aria-hidden=\"true\"><\/div>\n<\/form>\n<\/div>\n\n<\/div><\/div>\n","protected":false},"excerpt":{"rendered":"<p>Introduction Microsoft Excel is the most preferred program for people who work in data-related careers like financial analysis, investment banking, data processing and financial modelling and presentation. It is very popular and one of the basics taught in computer classes. Microsoft Excel is often considered to be the best industry standard piece of software when [&hellip;]<\/p>\n","protected":false},"author":90,"featured_media":25556511,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[802,1864,1841],"tags":[],"class_list":["post-25556505","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-articles","category-data-science-ml","category-entri-skilling"],"acf":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v26.6 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Basic Excel Formulas and Functions with Examples - Ultimate Guide<\/title>\n<meta name=\"description\" content=\"Discover the basic Excel formulas and functions with examples to create a strong foundation in your data science career!\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/entri.app\/blog\/basic-excel-formulas-and-functions\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Basic Excel Formulas and Functions with Examples - Ultimate Guide\" \/>\n<meta property=\"og:description\" content=\"Discover the basic Excel formulas and functions with examples to create a strong foundation in your data science career!\" \/>\n<meta property=\"og:url\" content=\"https:\/\/entri.app\/blog\/basic-excel-formulas-and-functions\/\" \/>\n<meta property=\"og:site_name\" content=\"Entri Blog\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/entri.me\/\" \/>\n<meta property=\"article:published_time\" content=\"2023-03-16T17:06:28+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2025-08-26T09:18:09+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/entri.app\/blog\/wp-content\/uploads\/2023\/03\/Untitled111.png\" \/>\n\t<meta property=\"og:image:width\" content=\"820\" \/>\n\t<meta property=\"og:image:height\" content=\"615\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"Sreevidya M\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@entri_app\" \/>\n<meta name=\"twitter:site\" content=\"@entri_app\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Sreevidya M\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"8 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/entri.app\/blog\/basic-excel-formulas-and-functions\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/entri.app\/blog\/basic-excel-formulas-and-functions\/\"},\"author\":{\"name\":\"Sreevidya M\",\"@id\":\"https:\/\/entri.app\/blog\/#\/schema\/person\/9f691436793528a81d4769f3fc0c62a8\"},\"headline\":\"Basic Excel Formulas and Functions with Examples\",\"datePublished\":\"2023-03-16T17:06:28+00:00\",\"dateModified\":\"2025-08-26T09:18:09+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/entri.app\/blog\/basic-excel-formulas-and-functions\/\"},\"wordCount\":1592,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/entri.app\/blog\/#organization\"},\"image\":{\"@id\":\"https:\/\/entri.app\/blog\/basic-excel-formulas-and-functions\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/entri.app\/blog\/wp-content\/uploads\/2023\/03\/Untitled111.png\",\"articleSection\":[\"Articles\",\"Data Science and Machine Learning\",\"Entri Skilling\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/entri.app\/blog\/basic-excel-formulas-and-functions\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/entri.app\/blog\/basic-excel-formulas-and-functions\/\",\"url\":\"https:\/\/entri.app\/blog\/basic-excel-formulas-and-functions\/\",\"name\":\"Basic Excel Formulas and Functions with Examples - Ultimate Guide\",\"isPartOf\":{\"@id\":\"https:\/\/entri.app\/blog\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/entri.app\/blog\/basic-excel-formulas-and-functions\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/entri.app\/blog\/basic-excel-formulas-and-functions\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/entri.app\/blog\/wp-content\/uploads\/2023\/03\/Untitled111.png\",\"datePublished\":\"2023-03-16T17:06:28+00:00\",\"dateModified\":\"2025-08-26T09:18:09+00:00\",\"description\":\"Discover the basic Excel formulas and functions with examples to create a strong foundation in your data science career!\",\"breadcrumb\":{\"@id\":\"https:\/\/entri.app\/blog\/basic-excel-formulas-and-functions\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/entri.app\/blog\/basic-excel-formulas-and-functions\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/entri.app\/blog\/basic-excel-formulas-and-functions\/#primaryimage\",\"url\":\"https:\/\/entri.app\/blog\/wp-content\/uploads\/2023\/03\/Untitled111.png\",\"contentUrl\":\"https:\/\/entri.app\/blog\/wp-content\/uploads\/2023\/03\/Untitled111.png\",\"width\":820,\"height\":615,\"caption\":\"Basic Excel Formulas and Functions\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/entri.app\/blog\/basic-excel-formulas-and-functions\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/entri.app\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Entri Skilling\",\"item\":\"https:\/\/entri.app\/blog\/category\/entri-skilling\/\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"Data Science and Machine Learning\",\"item\":\"https:\/\/entri.app\/blog\/category\/entri-skilling\/data-science-ml\/\"},{\"@type\":\"ListItem\",\"position\":4,\"name\":\"Basic Excel Formulas and Functions with Examples\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/entri.app\/blog\/#website\",\"url\":\"https:\/\/entri.app\/blog\/\",\"name\":\"Entri Blog\",\"description\":\"\",\"publisher\":{\"@id\":\"https:\/\/entri.app\/blog\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/entri.app\/blog\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/entri.app\/blog\/#organization\",\"name\":\"Entri App\",\"url\":\"https:\/\/entri.app\/blog\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/entri.app\/blog\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/entri.app\/blog\/wp-content\/uploads\/2019\/10\/Entri-Logo-1.png\",\"contentUrl\":\"https:\/\/entri.app\/blog\/wp-content\/uploads\/2019\/10\/Entri-Logo-1.png\",\"width\":989,\"height\":446,\"caption\":\"Entri App\"},\"image\":{\"@id\":\"https:\/\/entri.app\/blog\/#\/schema\/logo\/image\/\"},\"sameAs\":[\"https:\/\/www.facebook.com\/entri.me\/\",\"https:\/\/x.com\/entri_app\"]},{\"@type\":\"Person\",\"@id\":\"https:\/\/entri.app\/blog\/#\/schema\/person\/9f691436793528a81d4769f3fc0c62a8\",\"name\":\"Sreevidya M\",\"description\":\"Post-Graduate in English Language and Literature, freelance writer and an SSC aspirant. Provides updates on notifications, syllabuses and dates for government exams.\",\"url\":\"https:\/\/entri.app\/blog\/author\/sreevidya\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Basic Excel Formulas and Functions with Examples - Ultimate Guide","description":"Discover the basic Excel formulas and functions with examples to create a strong foundation in your data science career!","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/entri.app\/blog\/basic-excel-formulas-and-functions\/","og_locale":"en_US","og_type":"article","og_title":"Basic Excel Formulas and Functions with Examples - Ultimate Guide","og_description":"Discover the basic Excel formulas and functions with examples to create a strong foundation in your data science career!","og_url":"https:\/\/entri.app\/blog\/basic-excel-formulas-and-functions\/","og_site_name":"Entri Blog","article_publisher":"https:\/\/www.facebook.com\/entri.me\/","article_published_time":"2023-03-16T17:06:28+00:00","article_modified_time":"2025-08-26T09:18:09+00:00","og_image":[{"width":820,"height":615,"url":"https:\/\/entri.app\/blog\/wp-content\/uploads\/2023\/03\/Untitled111.png","type":"image\/png"}],"author":"Sreevidya M","twitter_card":"summary_large_image","twitter_creator":"@entri_app","twitter_site":"@entri_app","twitter_misc":{"Written by":"Sreevidya M","Est. reading time":"8 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/entri.app\/blog\/basic-excel-formulas-and-functions\/#article","isPartOf":{"@id":"https:\/\/entri.app\/blog\/basic-excel-formulas-and-functions\/"},"author":{"name":"Sreevidya M","@id":"https:\/\/entri.app\/blog\/#\/schema\/person\/9f691436793528a81d4769f3fc0c62a8"},"headline":"Basic Excel Formulas and Functions with Examples","datePublished":"2023-03-16T17:06:28+00:00","dateModified":"2025-08-26T09:18:09+00:00","mainEntityOfPage":{"@id":"https:\/\/entri.app\/blog\/basic-excel-formulas-and-functions\/"},"wordCount":1592,"commentCount":0,"publisher":{"@id":"https:\/\/entri.app\/blog\/#organization"},"image":{"@id":"https:\/\/entri.app\/blog\/basic-excel-formulas-and-functions\/#primaryimage"},"thumbnailUrl":"https:\/\/entri.app\/blog\/wp-content\/uploads\/2023\/03\/Untitled111.png","articleSection":["Articles","Data Science and Machine Learning","Entri Skilling"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/entri.app\/blog\/basic-excel-formulas-and-functions\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/entri.app\/blog\/basic-excel-formulas-and-functions\/","url":"https:\/\/entri.app\/blog\/basic-excel-formulas-and-functions\/","name":"Basic Excel Formulas and Functions with Examples - Ultimate Guide","isPartOf":{"@id":"https:\/\/entri.app\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/entri.app\/blog\/basic-excel-formulas-and-functions\/#primaryimage"},"image":{"@id":"https:\/\/entri.app\/blog\/basic-excel-formulas-and-functions\/#primaryimage"},"thumbnailUrl":"https:\/\/entri.app\/blog\/wp-content\/uploads\/2023\/03\/Untitled111.png","datePublished":"2023-03-16T17:06:28+00:00","dateModified":"2025-08-26T09:18:09+00:00","description":"Discover the basic Excel formulas and functions with examples to create a strong foundation in your data science career!","breadcrumb":{"@id":"https:\/\/entri.app\/blog\/basic-excel-formulas-and-functions\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/entri.app\/blog\/basic-excel-formulas-and-functions\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/entri.app\/blog\/basic-excel-formulas-and-functions\/#primaryimage","url":"https:\/\/entri.app\/blog\/wp-content\/uploads\/2023\/03\/Untitled111.png","contentUrl":"https:\/\/entri.app\/blog\/wp-content\/uploads\/2023\/03\/Untitled111.png","width":820,"height":615,"caption":"Basic Excel Formulas and Functions"},{"@type":"BreadcrumbList","@id":"https:\/\/entri.app\/blog\/basic-excel-formulas-and-functions\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/entri.app\/blog\/"},{"@type":"ListItem","position":2,"name":"Entri Skilling","item":"https:\/\/entri.app\/blog\/category\/entri-skilling\/"},{"@type":"ListItem","position":3,"name":"Data Science and Machine Learning","item":"https:\/\/entri.app\/blog\/category\/entri-skilling\/data-science-ml\/"},{"@type":"ListItem","position":4,"name":"Basic Excel Formulas and Functions with Examples"}]},{"@type":"WebSite","@id":"https:\/\/entri.app\/blog\/#website","url":"https:\/\/entri.app\/blog\/","name":"Entri Blog","description":"","publisher":{"@id":"https:\/\/entri.app\/blog\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/entri.app\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/entri.app\/blog\/#organization","name":"Entri App","url":"https:\/\/entri.app\/blog\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/entri.app\/blog\/#\/schema\/logo\/image\/","url":"https:\/\/entri.app\/blog\/wp-content\/uploads\/2019\/10\/Entri-Logo-1.png","contentUrl":"https:\/\/entri.app\/blog\/wp-content\/uploads\/2019\/10\/Entri-Logo-1.png","width":989,"height":446,"caption":"Entri App"},"image":{"@id":"https:\/\/entri.app\/blog\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/entri.me\/","https:\/\/x.com\/entri_app"]},{"@type":"Person","@id":"https:\/\/entri.app\/blog\/#\/schema\/person\/9f691436793528a81d4769f3fc0c62a8","name":"Sreevidya M","description":"Post-Graduate in English Language and Literature, freelance writer and an SSC aspirant. Provides updates on notifications, syllabuses and dates for government exams.","url":"https:\/\/entri.app\/blog\/author\/sreevidya\/"}]}},"_links":{"self":[{"href":"https:\/\/entri.app\/blog\/wp-json\/wp\/v2\/posts\/25556505","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/entri.app\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/entri.app\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/entri.app\/blog\/wp-json\/wp\/v2\/users\/90"}],"replies":[{"embeddable":true,"href":"https:\/\/entri.app\/blog\/wp-json\/wp\/v2\/comments?post=25556505"}],"version-history":[{"count":7,"href":"https:\/\/entri.app\/blog\/wp-json\/wp\/v2\/posts\/25556505\/revisions"}],"predecessor-version":[{"id":25621702,"href":"https:\/\/entri.app\/blog\/wp-json\/wp\/v2\/posts\/25556505\/revisions\/25621702"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/entri.app\/blog\/wp-json\/wp\/v2\/media\/25556511"}],"wp:attachment":[{"href":"https:\/\/entri.app\/blog\/wp-json\/wp\/v2\/media?parent=25556505"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/entri.app\/blog\/wp-json\/wp\/v2\/categories?post=25556505"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/entri.app\/blog\/wp-json\/wp\/v2\/tags?post=25556505"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}