{"id":23909,"date":"2025-08-01T12:50:42","date_gmt":"2025-08-01T07:20:42","guid":{"rendered":"https:\/\/www.pickl.ai\/blog\/?p=23909"},"modified":"2025-08-01T12:51:24","modified_gmt":"2025-08-01T07:21:24","slug":"basic-excel-formulas-list","status":"publish","type":"post","link":"https:\/\/www.pickl.ai\/blog\/basic-excel-formulas-list\/","title":{"rendered":"20 Basic Excel Formulas List"},"content":{"rendered":"\n<p><strong>Summary: <\/strong>Discover 20 essential Excel formulas designed to boost your productivity and data analysis skills. This guide covers everything from basic calculations like SUM and AVERAGE to powerful lookups like XLOOKUP and logical functions like IF. Master these to save time, reduce errors, and work more efficiently.<\/p>\n\n\n\n<div id=\"ez-toc-container\" class=\"ez-toc-v2_0_82_2 counter-hierarchy ez-toc-counter ez-toc-grey ez-toc-container-direction\">\n<div class=\"ez-toc-title-container\">\n<p class=\"ez-toc-title\" style=\"cursor:inherit\">Table of Contents<\/p>\n<span class=\"ez-toc-title-toggle\"><a href=\"#\" class=\"ez-toc-pull-right ez-toc-btn ez-toc-btn-xs ez-toc-btn-default ez-toc-toggle\" aria-label=\"Toggle Table of Content\"><span class=\"ez-toc-js-icon-con\"><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><\/span><\/a><\/span><\/div>\n<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:\/\/www.pickl.ai\/blog\/basic-excel-formulas-list\/#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:\/\/www.pickl.ai\/blog\/basic-excel-formulas-list\/#Key_Takeaways\" >Key Takeaways<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/www.pickl.ai\/blog\/basic-excel-formulas-list\/#Why_Excel_Formulas_Matter\" >Why Excel Formulas Matter<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-4\" href=\"https:\/\/www.pickl.ai\/blog\/basic-excel-formulas-list\/#Excel_Formulas_You_Should_Know\" >Excel Formulas You Should Know<\/a><ul class='ez-toc-list-level-3' ><li class='ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-5\" href=\"https:\/\/www.pickl.ai\/blog\/basic-excel-formulas-list\/#1_SUM\" >1. SUM<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-6\" href=\"https:\/\/www.pickl.ai\/blog\/basic-excel-formulas-list\/#2_AVERAGE\" >2. AVERAGE<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-7\" href=\"https:\/\/www.pickl.ai\/blog\/basic-excel-formulas-list\/#3_COUNT\" >3. COUNT<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-8\" href=\"https:\/\/www.pickl.ai\/blog\/basic-excel-formulas-list\/#4_MAX\" >4. MAX<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-9\" href=\"https:\/\/www.pickl.ai\/blog\/basic-excel-formulas-list\/#5_MIN\" >5. MIN<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-10\" href=\"https:\/\/www.pickl.ai\/blog\/basic-excel-formulas-list\/#6_IF\" >6. IF<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-11\" href=\"https:\/\/www.pickl.ai\/blog\/basic-excel-formulas-list\/#7_COUNTIF\" >7. COUNTIF<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-12\" href=\"https:\/\/www.pickl.ai\/blog\/basic-excel-formulas-list\/#8_SUMIF\" >8. SUMIF<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-13\" href=\"https:\/\/www.pickl.ai\/blog\/basic-excel-formulas-list\/#9_COUNTA\" >9. COUNTA<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-14\" href=\"https:\/\/www.pickl.ai\/blog\/basic-excel-formulas-list\/#10_VLOOKUP\" >10. VLOOKUP<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-15\" href=\"https:\/\/www.pickl.ai\/blog\/basic-excel-formulas-list\/#11_XLOOKUP\" >11. XLOOKUP<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-16\" href=\"https:\/\/www.pickl.ai\/blog\/basic-excel-formulas-list\/#12_INDEX_MATCH\" >12. INDEX &amp; MATCH<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-17\" href=\"https:\/\/www.pickl.ai\/blog\/basic-excel-formulas-list\/#13_CONCATENATE_or_CONCAT\" >13. CONCATENATE (or CONCAT)<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-18\" href=\"https:\/\/www.pickl.ai\/blog\/basic-excel-formulas-list\/#14_TRIM\" >14. TRIM<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-19\" href=\"https:\/\/www.pickl.ai\/blog\/basic-excel-formulas-list\/#15_16_UPPER_LOWER\" >15 &amp; 16. UPPER &amp; LOWER<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-20\" href=\"https:\/\/www.pickl.ai\/blog\/basic-excel-formulas-list\/#17_18_LEFT_RIGHT\" >17 &amp; 18. LEFT &amp; RIGHT<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-21\" href=\"https:\/\/www.pickl.ai\/blog\/basic-excel-formulas-list\/#19_TODAY\" >19. TODAY()<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-22\" href=\"https:\/\/www.pickl.ai\/blog\/basic-excel-formulas-list\/#20_IFERROR\" >20. IFERROR<\/a><\/li><\/ul><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-23\" href=\"https:\/\/www.pickl.ai\/blog\/basic-excel-formulas-list\/#Tips_for_Using_Formulas_Efficiently\" >Tips for Using Formulas Efficiently<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-24\" href=\"https:\/\/www.pickl.ai\/blog\/basic-excel-formulas-list\/#Frequently_Asked_Questions\" >Frequently Asked Questions<\/a><ul class='ez-toc-list-level-3' ><li class='ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-25\" href=\"https:\/\/www.pickl.ai\/blog\/basic-excel-formulas-list\/#What_is_an_Excel_formula\" >What is an Excel formula?<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-26\" href=\"https:\/\/www.pickl.ai\/blog\/basic-excel-formulas-list\/#How_do_you_create_a_simple_formula\" >How do you create a simple formula?<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-27\" href=\"https:\/\/www.pickl.ai\/blog\/basic-excel-formulas-list\/#What_is_the_difference_between_a_formula_and_a_function\" >What is the difference between a formula and a function?<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-28\" href=\"https:\/\/www.pickl.ai\/blog\/basic-excel-formulas-list\/#How_can_I_see_all_the_formulas_in_my_worksheet\" >How can I see all the formulas in my worksheet?<\/a><\/li><\/ul><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-29\" href=\"https:\/\/www.pickl.ai\/blog\/basic-excel-formulas-list\/#Conclusion\" >Conclusion<\/a><\/li><\/ul><\/nav><\/div>\n<h2 id=\"introduction\" class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"Introduction\"><\/span><strong>Introduction<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>In a world overflowing with data, Microsoft Excel remains a titan of data management and analysis. From organizing a simple shopping list to performing complex financial modeling, its power is undeniable. But the real secret to unlocking <a href=\"https:\/\/www.pickl.ai\/blog\/subtotal-formula-in-excel\/\">Excel&#8217;s potential lies within its formulas<\/a>.<\/p>\n\n\n\n<p>These expressions are the engine that automates tasks, ensures accuracy, and transforms rows of static data into dynamic, actionable insights.<\/p>\n\n\n\n<h2 id=\"key-takeaways\" class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"Key_Takeaways\"><\/span><strong>Key Takeaways<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<ol class=\"wp-block-list\">\n<li>Master core formulas like SUM, AVERAGE, and COUNT for quick calculations.<\/li>\n\n\n\n<li>Use the IF function to make decisions and automate workflow logic.<\/li>\n\n\n\n<li>Find specific data in large tables quickly with VLOOKUP or XLOOKUP.<\/li>\n\n\n\n<li>Clean and combine text easily using functions like TRIM and CONCAT.<\/li>\n\n\n\n<li>Handle formula errors gracefully with IFERROR and use cell references efficiently.<\/li>\n<\/ol>\n\n\n\n<h2 id=\"why-excel-formulas-matter\" class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"Why_Excel_Formulas_Matter\"><\/span><strong>Why Excel Formulas Matter<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>Excel formulas are the cornerstone of efficiency and precision. They are critical for automating repetitive calculations, which not only saves you a significant amount of time but also drastically reduces the risk of manual errors. Learning to use formulas is more than a technical skill; it&#8217;s about empowering yourself to work smarter.<\/p>\n\n\n\n<p>Whether you are a student, a business professional, or managing your personal finances, mastering these basic formulas will fundamentally improve your productivity and your ability to make data-informed decisions.<\/p>\n\n\n\n<h2 id=\"excel-formulas-you-should-know\" class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"Excel_Formulas_You_Should_Know\"><\/span><strong>Excel Formulas You Should Know<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<figure class=\"wp-block-image\"><img decoding=\"async\" src=\"https:\/\/lh7-rt.googleusercontent.com\/docsz\/AD_4nXedDyebFuDkFGmsNO0UG_b8bSnbNfNlg3KC9jo3e81B_WeWPzKbAfs0zBNN8p3_ZdCivbWUl14Qzc884oQpSfJFVreBfT9yliqxC4fQLGxg8RICpOcumrMyPBUuIXpjkTG31wdF?key=QnOhshIkNBD7_B2CsPMJpw\" alt=\"Excel formula mastery\"\/><\/figure>\n\n\n\n<p>Move beyond simple data entry and unlock Excel&#8217;s true potential with these essential formulas. Mastering these key functions is the first step to automating your workflow, saving significant time, reducing errors, and transforming how you work with data every day.<\/p>\n\n\n\n<h3 id=\"1-sum\" class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"1_SUM\"><\/span><strong>1.<\/strong> <strong>SUM<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<p>The most-used formula in <a href=\"https:\/\/www.pickl.ai\/blog\/step-by-step-guide-aging-formula-in-excel\/\">Excel<\/a>. It adds up all the numbers in a selected range of cells.<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>Syntax:<\/strong> =SUM(A2:A10)<\/li>\n\n\n\n<li><strong>Use Case:<\/strong> Quickly calculate the total sales, expenses, or any list of numbers.<\/li>\n<\/ul>\n\n\n\n<h3 id=\"2-average\" class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"2_AVERAGE\"><\/span><strong>2.<\/strong> <strong>AVERAGE<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<p>Calculates the arithmetic mean of a range of numbers.<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>Syntax:<\/strong> =AVERAGE(B2:B10)<\/li>\n\n\n\n<li><strong>Use Case:<\/strong> Find the average score of a test, average monthly rainfall, or average product rating.<\/li>\n<\/ul>\n\n\n\n<h3 id=\"3-count\" class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"3_COUNT\"><\/span><strong>3.<\/strong> <strong>COUNT<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<p><a href=\"https:\/\/www.pickl.ai\/blog\/how-to-use-count-in-excel-a-guide-to-the-count-function\/\">Counts<\/a> the number of cells in a range that contain numbers. It ignores text and empty cells.<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>Syntax:<\/strong> =COUNT(C2:C20)<\/li>\n\n\n\n<li><strong>Use Case:<\/strong> Determine how many sales transactions were made or how many students took an exam.<\/li>\n<\/ul>\n\n\n\n<h3 id=\"4-max\" class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"4_MAX\"><\/span><strong>4.<\/strong> <strong>MAX<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<p>Finds the highest or maximum value in a range of cells.<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>Syntax:<\/strong> =MAX(D2:D100)<\/li>\n\n\n\n<li><strong>Use Case:<\/strong> Identify the top sales figure, the highest temperature recorded, or the most expensive item on a list.<\/li>\n<\/ul>\n\n\n\n<h3 id=\"5-min\" class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"5_MIN\"><\/span><strong>5.<\/strong> <strong>MIN<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<p>The opposite of MAX, this function finds the lowest or minimum value in a range.<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>Syntax:<\/strong> =MIN(D2:D100)<\/li>\n\n\n\n<li><strong>Use Case:<\/strong> Find the lowest price, the fastest time in a race, or the smallest measurement.<\/li>\n<\/ul>\n\n\n\n<h3 id=\"6-if\" class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"6_IF\"><\/span><strong>6.<\/strong> <strong>IF<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<p>The ultimate logical function. It checks if a condition is true or false and returns a specific value for each outcome.<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>Syntax:<\/strong> =IF(logical_test, value_if_true, value_if_false)<\/li>\n\n\n\n<li><strong>Example:<\/strong> =IF(A2&gt;50, &#8220;Pass&#8221;, &#8220;Fail&#8221;) will return &#8220;Pass&#8221; if the score in A2 is over 50, and &#8220;Fail&#8221; otherwise.<\/li>\n<\/ul>\n\n\n\n<h3 id=\"7-countif\" class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"7_COUNTIF\"><\/span><strong>7.<\/strong> <strong>COUNTIF<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<p>Counts the number of cells within a range that meet a single, specific criterion.<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>Syntax:<\/strong> =COUNTIF(range, criteria)<\/li>\n\n\n\n<li><strong>Example:<\/strong> =COUNTIF(B2:B20, &#8220;London&#8221;) will count how many times the word &#8220;London&#8221; appears in that range.<\/li>\n<\/ul>\n\n\n\n<h3 id=\"8-sumif\" class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"8_SUMIF\"><\/span><strong>8.<\/strong> <strong>SUMIF<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<p>Adds the cells in a range that meet a specific criterion.<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>Syntax:<\/strong> =SUMIF(range, criteria, [sum_range])<\/li>\n\n\n\n<li><strong>Example:<\/strong> =SUMIF(A2:A10, &#8220;Fruit&#8221;, B2:B10) will sum the values in column B for every row where column A contains &#8220;Fruit&#8221;.<\/li>\n<\/ul>\n\n\n\n<h3 id=\"9-counta\" class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"9_COUNTA\"><\/span><strong>9.<\/strong> <strong>COUNTA<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<p>Unlike COUNT, this <a href=\"https:\/\/www.pickl.ai\/blog\/how-to-use-count-in-excel-a-guide-to-the-count-function\/\">function counts<\/a> the number of cells in a range that are not empty, including those with text, numbers, or errors.<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>Syntax:<\/strong> =COUNTA(A1:A100)<\/li>\n\n\n\n<li><strong>Use Case:<\/strong> Quickly see how many items are on a list, even if they are text-based.<\/li>\n<\/ul>\n\n\n\n<h3 id=\"10-vlookup\" class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"10_VLOOKUP\"><\/span><strong>10.<\/strong> <strong>VLOOKUP<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<p>The classic <a href=\"https:\/\/www.pickl.ai\/blog\/vlookup-in-excel\/\">&#8216;Vertical Lookup&#8217; function<\/a>. It searches for a value in the first column of a table and returns a corresponding value from another column in the same row.<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>Syntax:<\/strong> =VLOOKUP(lookup_value, table_array, col_index_num, [range_lookup])<\/li>\n\n\n\n<li><strong>Use Case:<\/strong> Find the price of a product by looking up its product ID in a table.<\/li>\n<\/ul>\n\n\n\n<h3 id=\"11-xlookup\" class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"11_XLOOKUP\"><\/span><strong>11.<\/strong> <strong>XLOOKUP<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<p>The modern, more powerful, and flexible successor to VLOOKUP and <a href=\"https:\/\/www.pickl.ai\/blog\/master-excels-hlookup-the-ultimate-guide-to-finding-data-faster\/\">HLOOKUP.<\/a> It\u2019s easier to use and overcomes many of their limitations.<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>Syntax:<\/strong> =XLOOKUP(lookup_value, lookup_array, return_array)<\/li>\n\n\n\n<li><strong>Use Case:<\/strong> A superior way to find related data without the column-counting or sorting restrictions of VLOOKUP.<\/li>\n<\/ul>\n\n\n\n<h3 id=\"12-index-match\" class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"12_INDEX_MATCH\"><\/span><strong>12.<\/strong> <strong>INDEX &amp; MATCH<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<p>Before XLOOKUP, this combination was the pro&#8217;s choice for advanced lookups. INDEX returns a value from a table based on a row and column number, while MATCH finds the position of a lookup value. Together, they are incredibly flexible.<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>Syntax:<\/strong> =INDEX(array, MATCH(lookup_value, lookup_array, 0))<\/li>\n\n\n\n<li><strong>Use Case:<\/strong> Perform complex lookups that can pull data from columns to the left of the lookup column.<\/li>\n<\/ul>\n\n\n\n<h3 id=\"13-concatenate-or-concat\" class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"13_CONCATENATE_or_CONCAT\"><\/span><strong>13.<\/strong> <strong>CONCATENATE (or CONCAT)<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<p>Joins text from two or more cells into one.<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>Syntax:<\/strong> =CONCAT(A2, &#8221; &#8220;, B2)<\/li>\n\n\n\n<li><strong>Use Case:<\/strong> Combine a first name in one column and a last name in another to create a full name.<\/li>\n<\/ul>\n\n\n\n<h3 id=\"14-trim\" class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"14_TRIM\"><\/span><strong>14.<\/strong> <strong>TRIM<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<p>Removes all extra spaces from text, leaving only single spaces between words.<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>Syntax:<\/strong> =TRIM(A2)<\/li>\n\n\n\n<li><strong>Use Case:<\/strong> Clean up data imported from other systems that may have inconsistent spacing.<\/li>\n<\/ul>\n\n\n\n<h3 id=\"15-16-upper-lower\" class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"15_16_UPPER_LOWER\"><\/span><strong>15 &amp; 16. UPPER &amp; LOWER<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<p>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Convert all letters in a text string to uppercase or lowercase, respectively.<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>Syntax:<\/strong> =UPPER(A2) or =LOWER(A2)<\/li>\n\n\n\n<li><strong>Use Case:<\/strong> Standardize text entries for consistent data analysis.<\/li>\n<\/ul>\n\n\n\n<h3 id=\"17-18-left-right\" class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"17_18_LEFT_RIGHT\"><\/span><strong>17 &amp; 18. LEFT &amp; RIGHT<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<p>Extract a specific number of characters from the beginning (LEFT) or end (RIGHT) of a text string.<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>Syntax:<\/strong> =LEFT(text, num_chars) or =RIGHT(text, num_chars)<\/li>\n\n\n\n<li><strong>Use Case:<\/strong> Extract the first three letters of a product code or the last four digits of a phone number.<\/li>\n<\/ul>\n\n\n\n<h3 id=\"19-today\" class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"19_TODAY\"><\/span><strong>19. TODAY()<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<p>Returns the current date. This formula is dynamic and will update every time the workbook is opened.<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>Syntax:<\/strong> =TODAY()<\/li>\n\n\n\n<li><strong>Use Case:<\/strong> Create a dashboard that always shows today&#8217;s date or calculate project days remaining.<\/li>\n<\/ul>\n\n\n\n<p><strong>Error Handling<\/strong><\/p>\n\n\n\n<p>Formulas don&#8217;t always work perfectly. This function helps you manage errors gracefully.<\/p>\n\n\n\n<h3 id=\"20-iferror\" class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"20_IFERROR\"><\/span><strong>20. IFERROR<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<p>Checks if a formula evaluates to an error and returns a custom value or message if it does.<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>Syntax:<\/strong> =IFERROR(formula, value_if_error)<\/li>\n\n\n\n<li><strong>Example:<\/strong> =IFERROR(A2\/B2, &#8220;Invalid Calculation&#8221;) will prevent the ugly #DIV\/0! error and show your message instead.<\/li>\n<\/ul>\n\n\n\n<h2 id=\"tips-for-using-formulas-efficiently\" class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"Tips_for_Using_Formulas_Efficiently\"><\/span><strong>Tips for Using Formulas Efficiently<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p><strong>Use Cell References<\/strong><\/p>\n\n\n\n<p>Instead of typing values directly into formulas (e.g., =5+10), refer to the cells containing those values (e.g., =A1+A2). This makes your formulas dynamic; if the data in the cells changes, the result automatically updates.<\/p>\n\n\n\n<p><strong>The Formula Bar<\/strong><\/p>\n\n\n\n<p>You can enter and edit formulas directly in a cell or in the formula bar located just above the worksheet grid.<\/p>\n\n\n\n<p><strong>Drag to Fill<\/strong><\/p>\n\n\n\n<p>Once you&#8217;ve written a formula, you can click the small square at the cell&#8217;s bottom-right corner (the fill handle) and drag it down or across to copy the formula to other cells.<\/p>\n\n\n\n<p><strong>Absolute vs. Relative References<\/strong><\/p>\n\n\n\n<p>By default, cell references are relative. When you copy a formula, these references adjust. To lock a reference to a specific cell, use a dollar sign ()tomakeitabsolute(e.g.,\u2018) to make it absolute (e.g., `)tomakeitabsolute(e.g.,\u2018A$1`).<\/p>\n\n\n\n<h2 id=\"frequently-asked-questions\" class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"Frequently_Asked_Questions\"><\/span><strong>Frequently Asked Questions<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<h3 id=\"what-is-an-excel-formula\" class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"What_is_an_Excel_formula\"><\/span><strong>What is an Excel formula?<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<p>An Excel formula is an expression used to perform calculations or <a href=\"https:\/\/www.pickl.ai\/blog\/data-manipulation-types-examples\/\">manipulate data.<\/a> It always starts with an equal sign (=) and can include values, cell references, operators (like + or *), and predefined functions (like SUM or IF) to produce a result in a cell.<\/p>\n\n\n\n<h3 id=\"how-do-you-create-a-simple-formula\" class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"How_do_you_create_a_simple_formula\"><\/span><strong>How do you create a simple formula?<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<p>To create a simple formula, select a cell, type an equal sign (=), and then enter your calculation. For example, to add the values in cells A1 and B1, you would type =A1+B1 and press Enter. The cell will then display the calculated result.<\/p>\n\n\n\n<h3 id=\"what-is-the-difference-between-a-formula-and-a-function\" class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"What_is_the_difference_between_a_formula_and_a_function\"><\/span><strong>What is the difference between a formula and a function?<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<p>A formula is any expression in Excel that starts with an equal sign. A function is a pre-built, named formula that simplifies complex calculations. For example, =A1+A2+A3 is a formula, while =SUM(A1:A3) is a formula that uses the SUM function to achieve the same result more efficiently.<\/p>\n\n\n\n<h3 id=\"how-can-i-see-all-the-formulas-in-my-worksheet\" class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"How_can_I_see_all_the_formulas_in_my_worksheet\"><\/span><strong>How can I see all the formulas in my worksheet?<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<p>You can view the formula of any single cell by selecting it and looking at the formula bar. To see all formulas on the worksheet at once instead of their results, you can press the `Ctrl + &#8220; (backtick) key combination. Pressing it again will toggle back to the results view.<\/p>\n\n\n\n<h2 id=\"conclusion\" class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"Conclusion\"><\/span>Conclusion<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>Matering this basic Excel formulas list is the first step toward true spreadsheet proficiency. These 20 functions are the foundation for automating tasks, ensuring accuracy, and deriving valuable insights from your data. By moving beyond manual entry and embracing the power of formulas, you don&#8217;t just become better at Excel\u2014you become more productive and effective in any data-handling role. Start practicing these simple but powerful tools today and watch your efficiency soar.<\/p>\n\n\n\n<p><\/p>\n\n\n\n<p><\/p>\n\n\n\n<p><\/p>\n","protected":false},"excerpt":{"rendered":"Your essential list of 20 basic Excel formulas for ultimate productivity and data mastery.\n","protected":false},"author":4,"featured_media":23968,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"om_disable_all_campaigns":false,"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"footnotes":""},"categories":[2318],"tags":[4093],"ppma_author":[2169,2607],"class_list":{"0":"post-23909","1":"post","2":"type-post","3":"status-publish","4":"format-standard","5":"has-post-thumbnail","7":"category-excel","8":"tag-excel-formulas-list"},"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v20.3 (Yoast SEO v27.3) - https:\/\/yoast.com\/product\/yoast-seo-premium-wordpress\/ -->\n<title>20 Excel Formulas List<\/title>\n<meta name=\"description\" content=\"Boost your productivity with our list of 20 essential Excel formulas list. Master key functions to automate tasks and analyze data like a pro.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.pickl.ai\/blog\/basic-excel-formulas-list\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"20 Basic Excel Formulas List\" \/>\n<meta property=\"og:description\" content=\"Boost your productivity with our list of 20 essential Excel formulas list. Master key functions to automate tasks and analyze data like a pro.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.pickl.ai\/blog\/basic-excel-formulas-list\/\" \/>\n<meta property=\"og:site_name\" content=\"Pickl.AI\" \/>\n<meta property=\"article:published_time\" content=\"2025-08-01T07:20:42+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2025-08-01T07:21:24+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.pickl.ai\/blog\/wp-content\/uploads\/2025\/08\/image2.png\" \/>\n\t<meta property=\"og:image:width\" content=\"800\" \/>\n\t<meta property=\"og:image:height\" content=\"494\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"Neha Singh, Hardik Agrawal\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Neha Singh\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"7 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/www.pickl.ai\\\/blog\\\/basic-excel-formulas-list\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.pickl.ai\\\/blog\\\/basic-excel-formulas-list\\\/\"},\"author\":{\"name\":\"Neha Singh\",\"@id\":\"https:\\\/\\\/www.pickl.ai\\\/blog\\\/#\\\/schema\\\/person\\\/2ad633a6bc1b93bc13591b60895be308\"},\"headline\":\"20 Basic Excel Formulas List\",\"datePublished\":\"2025-08-01T07:20:42+00:00\",\"dateModified\":\"2025-08-01T07:21:24+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/www.pickl.ai\\\/blog\\\/basic-excel-formulas-list\\\/\"},\"wordCount\":1520,\"commentCount\":0,\"image\":{\"@id\":\"https:\\\/\\\/www.pickl.ai\\\/blog\\\/basic-excel-formulas-list\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.pickl.ai\\\/blog\\\/wp-content\\\/uploads\\\/2025\\\/08\\\/image2.png\",\"keywords\":[\"Excel Formulas List\"],\"articleSection\":[\"Excel\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/www.pickl.ai\\\/blog\\\/basic-excel-formulas-list\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/www.pickl.ai\\\/blog\\\/basic-excel-formulas-list\\\/\",\"url\":\"https:\\\/\\\/www.pickl.ai\\\/blog\\\/basic-excel-formulas-list\\\/\",\"name\":\"20 Excel Formulas List\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.pickl.ai\\\/blog\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/www.pickl.ai\\\/blog\\\/basic-excel-formulas-list\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/www.pickl.ai\\\/blog\\\/basic-excel-formulas-list\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.pickl.ai\\\/blog\\\/wp-content\\\/uploads\\\/2025\\\/08\\\/image2.png\",\"datePublished\":\"2025-08-01T07:20:42+00:00\",\"dateModified\":\"2025-08-01T07:21:24+00:00\",\"author\":{\"@id\":\"https:\\\/\\\/www.pickl.ai\\\/blog\\\/#\\\/schema\\\/person\\\/2ad633a6bc1b93bc13591b60895be308\"},\"description\":\"Boost your productivity with our list of 20 essential Excel formulas list. Master key functions to automate tasks and analyze data like a pro.\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/www.pickl.ai\\\/blog\\\/basic-excel-formulas-list\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/www.pickl.ai\\\/blog\\\/basic-excel-formulas-list\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/www.pickl.ai\\\/blog\\\/basic-excel-formulas-list\\\/#primaryimage\",\"url\":\"https:\\\/\\\/www.pickl.ai\\\/blog\\\/wp-content\\\/uploads\\\/2025\\\/08\\\/image2.png\",\"contentUrl\":\"https:\\\/\\\/www.pickl.ai\\\/blog\\\/wp-content\\\/uploads\\\/2025\\\/08\\\/image2.png\",\"width\":800,\"height\":494,\"caption\":\"Excel Formulas List\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/www.pickl.ai\\\/blog\\\/basic-excel-formulas-list\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/www.pickl.ai\\\/blog\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Excel\",\"item\":\"https:\\\/\\\/www.pickl.ai\\\/blog\\\/category\\\/excel\\\/\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"20 Basic Excel Formulas List\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/www.pickl.ai\\\/blog\\\/#website\",\"url\":\"https:\\\/\\\/www.pickl.ai\\\/blog\\\/\",\"name\":\"Pickl.AI\",\"description\":\"\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/www.pickl.ai\\\/blog\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/www.pickl.ai\\\/blog\\\/#\\\/schema\\\/person\\\/2ad633a6bc1b93bc13591b60895be308\",\"name\":\"Neha Singh\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/pickl.ai\\\/blog\\\/wp-content\\\/uploads\\\/2024\\\/06\\\/avatar_user_4_1717572961-96x96.jpg3d1a0d35d7a1a929f4a120e9053cbdb5\",\"url\":\"https:\\\/\\\/pickl.ai\\\/blog\\\/wp-content\\\/uploads\\\/2024\\\/06\\\/avatar_user_4_1717572961-96x96.jpg\",\"contentUrl\":\"https:\\\/\\\/pickl.ai\\\/blog\\\/wp-content\\\/uploads\\\/2024\\\/06\\\/avatar_user_4_1717572961-96x96.jpg\",\"caption\":\"Neha Singh\"},\"description\":\"I\u2019m a full-time freelance writer and editor who enjoys wordsmithing. The 8 years long journey as a content writer and editor has made me relaize the significance and power of choosing the right words. Prior to my writing journey, I was a trainer and human resource manager. WIth more than a decade long professional journey, I find myself more powerful as a wordsmith. As an avid writer, everything around me inspires me and pushes me to string words and ideas to create unique content; and when I\u2019m not writing and editing, I enjoy experimenting with my culinary skills, reading, gardening, and spending time with my adorable little mutt Neel.\",\"url\":\"https:\\\/\\\/www.pickl.ai\\\/blog\\\/author\\\/nehasingh\\\/\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"20 Excel Formulas List","description":"Boost your productivity with our list of 20 essential Excel formulas list. Master key functions to automate tasks and analyze data like a pro.","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:\/\/www.pickl.ai\/blog\/basic-excel-formulas-list\/","og_locale":"en_US","og_type":"article","og_title":"20 Basic Excel Formulas List","og_description":"Boost your productivity with our list of 20 essential Excel formulas list. Master key functions to automate tasks and analyze data like a pro.","og_url":"https:\/\/www.pickl.ai\/blog\/basic-excel-formulas-list\/","og_site_name":"Pickl.AI","article_published_time":"2025-08-01T07:20:42+00:00","article_modified_time":"2025-08-01T07:21:24+00:00","og_image":[{"width":800,"height":494,"url":"https:\/\/www.pickl.ai\/blog\/wp-content\/uploads\/2025\/08\/image2.png","type":"image\/png"}],"author":"Neha Singh, Hardik Agrawal","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Neha Singh","Est. reading time":"7 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.pickl.ai\/blog\/basic-excel-formulas-list\/#article","isPartOf":{"@id":"https:\/\/www.pickl.ai\/blog\/basic-excel-formulas-list\/"},"author":{"name":"Neha Singh","@id":"https:\/\/www.pickl.ai\/blog\/#\/schema\/person\/2ad633a6bc1b93bc13591b60895be308"},"headline":"20 Basic Excel Formulas List","datePublished":"2025-08-01T07:20:42+00:00","dateModified":"2025-08-01T07:21:24+00:00","mainEntityOfPage":{"@id":"https:\/\/www.pickl.ai\/blog\/basic-excel-formulas-list\/"},"wordCount":1520,"commentCount":0,"image":{"@id":"https:\/\/www.pickl.ai\/blog\/basic-excel-formulas-list\/#primaryimage"},"thumbnailUrl":"https:\/\/www.pickl.ai\/blog\/wp-content\/uploads\/2025\/08\/image2.png","keywords":["Excel Formulas List"],"articleSection":["Excel"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.pickl.ai\/blog\/basic-excel-formulas-list\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.pickl.ai\/blog\/basic-excel-formulas-list\/","url":"https:\/\/www.pickl.ai\/blog\/basic-excel-formulas-list\/","name":"20 Excel Formulas List","isPartOf":{"@id":"https:\/\/www.pickl.ai\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.pickl.ai\/blog\/basic-excel-formulas-list\/#primaryimage"},"image":{"@id":"https:\/\/www.pickl.ai\/blog\/basic-excel-formulas-list\/#primaryimage"},"thumbnailUrl":"https:\/\/www.pickl.ai\/blog\/wp-content\/uploads\/2025\/08\/image2.png","datePublished":"2025-08-01T07:20:42+00:00","dateModified":"2025-08-01T07:21:24+00:00","author":{"@id":"https:\/\/www.pickl.ai\/blog\/#\/schema\/person\/2ad633a6bc1b93bc13591b60895be308"},"description":"Boost your productivity with our list of 20 essential Excel formulas list. Master key functions to automate tasks and analyze data like a pro.","breadcrumb":{"@id":"https:\/\/www.pickl.ai\/blog\/basic-excel-formulas-list\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.pickl.ai\/blog\/basic-excel-formulas-list\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.pickl.ai\/blog\/basic-excel-formulas-list\/#primaryimage","url":"https:\/\/www.pickl.ai\/blog\/wp-content\/uploads\/2025\/08\/image2.png","contentUrl":"https:\/\/www.pickl.ai\/blog\/wp-content\/uploads\/2025\/08\/image2.png","width":800,"height":494,"caption":"Excel Formulas List"},{"@type":"BreadcrumbList","@id":"https:\/\/www.pickl.ai\/blog\/basic-excel-formulas-list\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.pickl.ai\/blog\/"},{"@type":"ListItem","position":2,"name":"Excel","item":"https:\/\/www.pickl.ai\/blog\/category\/excel\/"},{"@type":"ListItem","position":3,"name":"20 Basic Excel Formulas List"}]},{"@type":"WebSite","@id":"https:\/\/www.pickl.ai\/blog\/#website","url":"https:\/\/www.pickl.ai\/blog\/","name":"Pickl.AI","description":"","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.pickl.ai\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/www.pickl.ai\/blog\/#\/schema\/person\/2ad633a6bc1b93bc13591b60895be308","name":"Neha Singh","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/pickl.ai\/blog\/wp-content\/uploads\/2024\/06\/avatar_user_4_1717572961-96x96.jpg3d1a0d35d7a1a929f4a120e9053cbdb5","url":"https:\/\/pickl.ai\/blog\/wp-content\/uploads\/2024\/06\/avatar_user_4_1717572961-96x96.jpg","contentUrl":"https:\/\/pickl.ai\/blog\/wp-content\/uploads\/2024\/06\/avatar_user_4_1717572961-96x96.jpg","caption":"Neha Singh"},"description":"I\u2019m a full-time freelance writer and editor who enjoys wordsmithing. The 8 years long journey as a content writer and editor has made me relaize the significance and power of choosing the right words. Prior to my writing journey, I was a trainer and human resource manager. WIth more than a decade long professional journey, I find myself more powerful as a wordsmith. As an avid writer, everything around me inspires me and pushes me to string words and ideas to create unique content; and when I\u2019m not writing and editing, I enjoy experimenting with my culinary skills, reading, gardening, and spending time with my adorable little mutt Neel.","url":"https:\/\/www.pickl.ai\/blog\/author\/nehasingh\/"}]}},"jetpack_featured_media_url":"https:\/\/www.pickl.ai\/blog\/wp-content\/uploads\/2025\/08\/image2.png","authors":[{"term_id":2169,"user_id":4,"is_guest":0,"slug":"nehasingh","display_name":"Neha Singh","avatar_url":"https:\/\/pickl.ai\/blog\/wp-content\/uploads\/2024\/06\/avatar_user_4_1717572961-96x96.jpg","first_name":"Neha","user_url":"","last_name":"Singh","description":"I\u2019m a full-time freelance writer and editor who enjoys wordsmithing. The 8 years long journey as a content writer and editor has made me relaize the significance and power of choosing the right words. Prior to my writing journey, I was a trainer and human resource manager. WIth more than a decade long professional journey, I find myself more powerful as a wordsmith. As an avid writer, everything around me inspires me and pushes me to string words and ideas to create unique content; and when I\u2019m not writing and editing, I enjoy experimenting with my culinary skills, reading, gardening, and spending time with my adorable little mutt Neel."},{"term_id":2607,"user_id":45,"is_guest":0,"slug":"hardikagrawal","display_name":"Hardik Agrawal","avatar_url":"https:\/\/pickl.ai\/blog\/wp-content\/uploads\/2024\/07\/avatar_user_45_1721995960-96x96.jpeg","first_name":"Hardik","user_url":"","last_name":"Agrawal","description":"Hardik Agrawal has graduated with a B.Tech in Production and Industrial Engineering from IIT Delhi in 2024. His expertise lies in Data Science, Machine Learning, and SQL. He has hobbies like reading novels, venturing into new locations, and watching sci-fi movies."}],"_links":{"self":[{"href":"https:\/\/www.pickl.ai\/blog\/wp-json\/wp\/v2\/posts\/23909","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.pickl.ai\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.pickl.ai\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.pickl.ai\/blog\/wp-json\/wp\/v2\/users\/4"}],"replies":[{"embeddable":true,"href":"https:\/\/www.pickl.ai\/blog\/wp-json\/wp\/v2\/comments?post=23909"}],"version-history":[{"count":5,"href":"https:\/\/www.pickl.ai\/blog\/wp-json\/wp\/v2\/posts\/23909\/revisions"}],"predecessor-version":[{"id":25281,"href":"https:\/\/www.pickl.ai\/blog\/wp-json\/wp\/v2\/posts\/23909\/revisions\/25281"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.pickl.ai\/blog\/wp-json\/wp\/v2\/media\/23968"}],"wp:attachment":[{"href":"https:\/\/www.pickl.ai\/blog\/wp-json\/wp\/v2\/media?parent=23909"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.pickl.ai\/blog\/wp-json\/wp\/v2\/categories?post=23909"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.pickl.ai\/blog\/wp-json\/wp\/v2\/tags?post=23909"},{"taxonomy":"author","embeddable":true,"href":"https:\/\/www.pickl.ai\/blog\/wp-json\/wp\/v2\/ppma_author?post=23909"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}