{"id":1654,"date":"2018-03-28T18:00:00","date_gmt":"2018-03-28T16:00:00","guid":{"rendered":"https:\/\/demo.sidekick.be\/itenium\/excel-formulas-cheat-sheet\/"},"modified":"2025-11-28T13:31:46","modified_gmt":"2025-11-28T12:31:46","slug":"excel-formulas-cheat-sheet","status":"publish","type":"post","link":"https:\/\/demo.sidekick.be\/itenium\/blog\/dotnet\/excel-formulas-cheat-sheet\/","title":{"rendered":"Excel formulas cheat sheet"},"content":{"rendered":"<p><\/p>\n<hr \/>\n<p><\/p>\n<h1 id=\"thats-fine\">That\u2019s fine!<\/h1>\n<p>Companion to the EPPlus series, specifically to Part 2: Formulas.<br \/> Covering the EPPlus syntax and implemented functions.<\/p>\n<h1 id=\"basics\">Basics<\/h1>\n<p>Add a formula with:<\/p>\n<pre><code>var package = new ExcelPackage();\nvar sheet = package.Workbook.Worksheets.Add(\"Formulas\")\nsheet.Cells[\"A1\"].Formula = \"A$5\";\nsheet.Cells[\"D5\"].FormulaR1C1 = \"RC[-2]*RC[-1]\";\n<\/code><\/pre>\n<p>A few EPPlus specific gotchas:<\/p>\n<ul>\n<li>Do not start .Formula with =<\/li>\n<li>Use English function names<\/li>\n<li>Use , as function parameter separator<\/li>\n<\/ul>\n<h1 id=\"string-manipulation\">String manipulation<\/h1>\n<p>All string indexes start from 1.<\/p>\n<table class=\"table-code\">\n<thead>\n<tr>\n<th>Function<\/th>\n<th>C#<\/th>\n<th>Remarks<\/th>\n<\/tr>\n<\/thead>\n<tbody>\n<tr>\n<td>LEN(str)<\/td>\n<td>str.Length<\/td>\n<td><\/td>\n<\/tr>\n<tr>\n<td>TRIM(str)<\/td>\n<td>str.Trim<\/td>\n<td><\/td>\n<\/tr>\n<tr>\n<td>LOWER(str)<\/td>\n<td>str.ToLower<\/td>\n<td><\/td>\n<\/tr>\n<tr>\n<td>UPPER(str)<\/td>\n<td>str.ToUpper<\/td>\n<td><\/td>\n<\/tr>\n<tr>\n<td>PROPER(str)<\/td>\n<td>To Title Case &#8211; Like This<\/td>\n<td><\/td>\n<\/tr>\n<tr>\n<td>LEFT(str, cnt)<\/td>\n<td>str.Substring(0, cnt)<\/td>\n<td>Also: RIGHT<\/td>\n<\/tr>\n<tr>\n<td>MID(str, start, length)<\/td>\n<td>str.Substring(start &#8211; 1, length)<\/td>\n<td><\/td>\n<\/tr>\n<tr>\n<td>REPLACE(str, startIndex, length, newStr)<\/td>\n<td>Use SUBSTITUTE instead<\/td>\n<td><\/td>\n<\/tr>\n<tr>\n<td>SUBSTITUTE(str, \u201cthe\u201d, \u201ca\u201d)<\/td>\n<td>str.Replace(\u201cthe\u201d, \u201ca\u201d)<\/td>\n<td><\/td>\n<\/tr>\n<tr>\n<td>REPT(str, number)<\/td>\n<td>string.Concat(Enumerable.Repeat(str, number))<\/td>\n<td><\/td>\n<\/tr>\n<tr>\n<td>CONCATENATE(str1, str2, \u2026)<\/td>\n<td>str1 + str2<\/td>\n<td><\/td>\n<\/tr>\n<tr>\n<td>str1 &amp; str2<\/td>\n<td>str1 + str2<\/td>\n<td><\/td>\n<\/tr>\n<tr>\n<td>FIND(str, needle)<\/td>\n<td>str.IndexOf(needle) + 1<\/td>\n<td>Case sensitive<\/td>\n<\/tr>\n<tr>\n<td>SEARCH(str, needle)<\/td>\n<td>Case insensitive FIND<\/td>\n<td><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<h1 id=\"numbers--math\">Numbers &amp; Math<\/h1>\n<table class=\"table-code\">\n<thead>\n<tr>\n<th>Function<\/th>\n<th>Meaning<\/th>\n<\/tr>\n<\/thead>\n<tbody>\n<tr>\n<td>VALUE(str)<\/td>\n<td>decimal.Parse(str)<\/td>\n<\/tr>\n<tr>\n<td>FLOOR(number, significance)<\/td>\n<td>Or INT, ROUNDDOWN, TRUNC<\/td>\n<\/tr>\n<tr>\n<td>CEILING(number, significance)<\/td>\n<td>Or ROUNDUP<\/td>\n<\/tr>\n<tr>\n<td>ROUND(number, significance)<\/td>\n<td><\/td>\n<\/tr>\n<tr>\n<td>ISNUMBER, ISEVEN, ISODD<\/td>\n<td><\/td>\n<\/tr>\n<tr>\n<td>MAX, MIN<\/td>\n<td><\/td>\n<\/tr>\n<tr>\n<td>COUNT(range)<\/td>\n<td>Counts all numeric cell values<\/td>\n<\/tr>\n<tr>\n<td>COUNTA(range)<\/td>\n<td>Counts all non empty cell values<\/td>\n<\/tr>\n<tr>\n<td>COUNTBLANK(range)<\/td>\n<td><\/td>\n<\/tr>\n<tr>\n<td>COUNTIF(range, criteria)<\/td>\n<td><\/td>\n<\/tr>\n<tr>\n<td>COUNTIFS(range, criteria, range2, crit2)<\/td>\n<td><\/td>\n<\/tr>\n<tr>\n<td>SUM, SUMIF, SUMIFS<\/td>\n<td><\/td>\n<\/tr>\n<tr>\n<td>AVERAGE, AVERAGEIF, AVERAGEIFS<\/td>\n<td><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<h2 id=\"countif-sumif-averageif\">CountIf, SumIf, AverageIf<\/h2>\n<p>Criteria possibilities for these xxxIF functions:<\/p>\n<ul>\n<li>A literal (ex: 15 or \u201cvalue\u201d)<\/li>\n<li>Another cell or function result<\/li>\n<li><code>\"&gt;=10\"<\/code>, <code>\"=0\"<\/code>, \u2026<\/li>\n<li><code>\"&lt;&gt;\"&amp;A1<\/code>: not equal to A1<\/li>\n<li><code>\"gr?y\"<\/code>: single letter wildcard<\/li>\n<li><code>\"cat*\"<\/code>: 0..x wildcard<\/li>\n<\/ul>\n<h2 id=\"real-mathy\">Real mathy<\/h2>\n<table class=\"table-code\">\n<thead>\n<tr>\n<th>Function<\/th>\n<th>Meaning<\/th>\n<\/tr>\n<\/thead>\n<tbody>\n<tr>\n<td>ABS(number)<\/td>\n<td>Absolute value<\/td>\n<\/tr>\n<tr>\n<td>SIGN(number)<\/td>\n<td>Returns 1 or -1<\/td>\n<\/tr>\n<tr>\n<td>PRODUCT(range\u2026)<\/td>\n<td>Returns arg1 * arg2 * \u2026<\/td>\n<\/tr>\n<tr>\n<td>POWER(base, exponent)<\/td>\n<td>Or base^exp. Also: SQRT<\/td>\n<\/tr>\n<tr>\n<td>MOD(dividend, divisor)<\/td>\n<td>Modulo. Also: QUOTIENT<\/td>\n<\/tr>\n<tr>\n<td>RAND()<\/td>\n<td>Between 0 and 1<\/td>\n<\/tr>\n<tr>\n<td>RANDBETWEEN(low, high)<\/td>\n<td>Both params inclusive<\/td>\n<\/tr>\n<tr>\n<td>LARGE(range, xth)<\/td>\n<td>Returns xth largest number<\/td>\n<\/tr>\n<tr>\n<td>SMALL(range, xth)<\/td>\n<td>Returns xth smallest number<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p>And then a whole bunch like:<\/p>\n<ul>\n<li>PI, SIN, COS, ASIN, ASINH, TAN, ATAN, \u2026<\/li>\n<li>EXP, LOG, LOG10, LN<\/li>\n<li>MEDIAN, STDEV, RANK, VAR<\/li>\n<\/ul>\n<h2 id=\"subtotal\">SUBTOTAL<\/h2>\n<p>SUBTOTAL(9,\u2026), as apposed to using SUM directly, will not include other subtotals in the calculation.<\/p>\n<pre><code class=\"language-vba\">SUBTOTAL(FUNC_NUM,ref1,[ref2],...)\n<\/code><\/pre>\n<p>Add 100 to FUNC_NUM to ignore manually hidden rows. Filtered-out rows are always excluded.<\/p>\n<table class=\"table-code\">\n<thead>\n<tr>\n<th>FUNC_NUM<\/th>\n<th>Function name<\/th>\n<th>Desc<\/th>\n<\/tr>\n<\/thead>\n<tbody>\n<tr>\n<td>1<\/td>\n<td>AVERAGE<\/td>\n<td><\/td>\n<\/tr>\n<tr>\n<td>2<\/td>\n<td>COUNT<\/td>\n<td>Counts how many numbers<\/td>\n<\/tr>\n<tr>\n<td>3<\/td>\n<td>COUNTA<\/td>\n<td>Counts how many values<\/td>\n<\/tr>\n<tr>\n<td>4<\/td>\n<td>MAX<\/td>\n<td><\/td>\n<\/tr>\n<tr>\n<td>5<\/td>\n<td>MIN<\/td>\n<td><\/td>\n<\/tr>\n<tr>\n<td>6<\/td>\n<td>PRODUCT<\/td>\n<td><\/td>\n<\/tr>\n<tr>\n<td>7<\/td>\n<td>STDEV<\/td>\n<td>Estimates standard deviation based on a sample<\/td>\n<\/tr>\n<tr>\n<td>8<\/td>\n<td>STDEVP<\/td>\n<td>Calculates standard deviation based on the entire population<\/td>\n<\/tr>\n<tr>\n<td>9<\/td>\n<td>SUM<\/td>\n<td><\/td>\n<\/tr>\n<tr>\n<td>10<\/td>\n<td>VAR<\/td>\n<td>Estimates variance based on a sample<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<h1 id=\"date--time\">Date &amp; Time<\/h1>\n<table class=\"table-code\">\n<thead>\n<tr>\n<th>Function<\/th>\n<th>C#<\/th>\n<\/tr>\n<\/thead>\n<tbody>\n<tr>\n<td>DATE(year, month, day)<\/td>\n<td>new DateTime(year, month, day)<\/td>\n<\/tr>\n<tr>\n<td>TODAY<\/td>\n<td>DateTime.Now.Date<\/td>\n<\/tr>\n<tr>\n<td>NOW<\/td>\n<td>DateTime.Now<\/td>\n<\/tr>\n<tr>\n<td>DATE(date)<\/td>\n<td>date.Date<\/td>\n<\/tr>\n<tr>\n<td>Also: MONTH, YEAR, TIME, HOUR, MINUTE, SECOND<\/td>\n<td><\/td>\n<\/tr>\n<tr>\n<td>WEEKNUM<\/td>\n<td>Week of year. Also: ISOWEEKNUM<\/td>\n<\/tr>\n<tr>\n<td>WEEKDAY<\/td>\n<td>Day of week index (sunday=0)<\/td>\n<\/tr>\n<tr>\n<td><\/td>\n<td><\/td>\n<\/tr>\n<tr>\n<td>Calculations:<\/td>\n<td><\/td>\n<\/tr>\n<tr>\n<td>TODAY() &#8211; 2<\/td>\n<td>DateTime.Now.Date.Subtract(TimeSpan.FromDays(2))<\/td>\n<\/tr>\n<tr>\n<td>NOW() + \u201c2:00\u201d<\/td>\n<td>DateTime.Now.Add(TimeSpan.FromHours(2))<\/td>\n<\/tr>\n<tr>\n<td>DAYS360(date1, date2)<\/td>\n<td>Difference in days<\/td>\n<\/tr>\n<tr>\n<td>YEARFRAC(date1, date2)<\/td>\n<td>Difference in years (including fractional part)<\/td>\n<\/tr>\n<tr>\n<td>EDATE(date, nrOfMonths)<\/td>\n<td>Add nrOfMonths to date<\/td>\n<\/tr>\n<tr>\n<td>EOMONTHS(date, 0)<\/td>\n<td>Returns the last day of the date month<\/td>\n<\/tr>\n<tr>\n<td>EOMONTHS(date, -2)<\/td>\n<td>Returns the last day of the month of (date &#8211; 2 months)<\/td>\n<\/tr>\n<tr>\n<td>WORKDAY(date, workDaysToAdd, holidaysRange)<\/td>\n<td>Add working days to date. holidaysRange is optional<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<h1 id=\"boolean-logic\">Boolean logic<\/h1>\n<table class=\"table-code\">\n<thead>\n<tr>\n<th>Function<\/th>\n<th>Meaning<\/th>\n<\/tr>\n<\/thead>\n<tbody>\n<tr>\n<td>ISBLANK<\/td>\n<td><\/td>\n<\/tr>\n<tr>\n<td>ISTEXT, ISNONTEXT<\/td>\n<td><\/td>\n<\/tr>\n<tr>\n<td>T(A1)<\/td>\n<td>typeof A1 === \u201cstring\u201d ? A1 : \u201c\u201d<\/td>\n<\/tr>\n<tr>\n<td>EXACT(strA, strB)<\/td>\n<td>strA == strB. Case sensitive.<\/td>\n<\/tr>\n<tr>\n<td>ISNUMBER, ISEVEN, ISODD<\/td>\n<td><\/td>\n<\/tr>\n<tr>\n<td>ISLOGICAL<\/td>\n<td>Is a boolean?<\/td>\n<\/tr>\n<tr>\n<td>TRUE(), FALSE()<\/td>\n<td>True\/False values<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<h2 id=\"or-and-not\">Or, And, Not<\/h2>\n<pre><code>' Check if cell is blank\nIF(OR(ISBLANK(A1), TRIM(A1)=\"\"), 1, 0)\n\n' Check if cell is either value\nIF(OR(A1=\"value\", A1=\"value2\"), \"value1-2\", \"other\")\n<\/code><\/pre>\n<h1>Also in this series<\/h1>\n<ul>\n<li>Part 1: <a href=\"\/dotnet\/create-xlsx-excel-with-epplus-csharp\/\">Create Excels with C# and EPPlus: A tutorial<\/a><\/li>\n<li>Part 2: <a href=\"\/dotnet\/create-xlsx-excel-with-epplus-csharp-formulas-and-datavalidation\/\">Create Excels with C# and EPPlus: Formulas &#038; DataValidation<\/a><\/li>\n<li>Part 3: <a href=\"\/dotnet\/create-xlsx-excel-with-epplus-csharp-import\/\">Create Excels with C# and EPPlus: Import<\/a><\/li>\n<li>Part 4: <a href=\"\/dotnet\/create-xlsx-excel-with-epplus-csharp-miscellaneous\/\">Create Excels with C# and EPPlus: Miscellaneous<\/a><\/li>\n<li>This Part: Excel formulas cheat sheet<\/li>\n<li>Part 6: <a href=\"\/dotnet\/epplus-pay-to-play\/\">EPPlus: No longer free to use in a commercial setting<\/a><\/li>\n<\/ul>\n<h1>Extras<\/h1>\n<p><b>Stuff that came into being during the making of this post<\/b><\/p>\n<ul>\n<li><a href=\"https:\/\/github.com\/itenium-be\/EPPlusTutorial\">The accompanying source on GitHub<\/a><\/li>\n<\/ul>\n<p><b>Other interesting reads<\/b><\/p>\n<ul>\n<li><a href=\"https:\/\/support.office.com\/en-us\/article\/Excel-functions-alphabetical-b3944572-255d-4efb-bb96-c6d90033e188\">Official documentation: list of all Excel functions<\/a><\/li>\n<\/ul>\n","protected":false},"excerpt":{"rendered":"<p class=\"notice--danger\"><strong>Version 4.5.3.3 is the last version of EPPlus you can use without a license for commercial use.<\/strong><br \/> See <a href=\"\/blog\/dotnet\/epplus-pay-to-play\/\">some alternatives<\/a> if that is a dealbreaker for you!<\/p>\n<p class=\"notice--info\"><strong>We now have a blog series on an alternative Excel package <a href=\"\/blog\/dotnet\/excel-formulas-cheat-sheet-closedxml\">ClosedXML<\/a><\/strong><br \/> Which is basically on equal footing with EPPlus.<\/p>\n","protected":false},"author":1,"featured_media":2105,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"inline_featured_image":false,"footnotes":""},"categories":[11],"tags":[13,12],"class_list":["post-1654","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-dotnet","tag-cheat-sheet","tag-excel"],"acf":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v26.5 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Excel formulas cheat sheet - Itenium<\/title>\n<meta name=\"robots\" content=\"noindex, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Excel formulas cheat sheet - Itenium\" \/>\n<meta property=\"og:description\" content=\"Version 4.5.3.3 is the last version of EPPlus you can use without a license for commercial use. See some alternatives if that is a dealbreaker for you!We now have a blog series on an alternative Excel package ClosedXML Which is basically on equal footing with EPPlus.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/demo.sidekick.be\/itenium\/blog\/dotnet\/excel-formulas-cheat-sheet\/\" \/>\n<meta property=\"og:site_name\" content=\"Itenium\" \/>\n<meta property=\"article:published_time\" content=\"2018-03-28T16:00:00+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2025-11-28T12:31:46+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/demo.sidekick.be\/itenium\/wp-content\/uploads\/2025\/11\/excel-math.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"360\" \/>\n\t<meta property=\"og:image:height\" content=\"300\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"author\" content=\"Usdevelop\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Usdevelop\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"3 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/demo.sidekick.be\/itenium\/blog\/dotnet\/excel-formulas-cheat-sheet\/\",\"url\":\"https:\/\/demo.sidekick.be\/itenium\/blog\/dotnet\/excel-formulas-cheat-sheet\/\",\"name\":\"Excel formulas cheat sheet - Itenium\",\"isPartOf\":{\"@id\":\"https:\/\/demo.sidekick.be\/itenium\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/demo.sidekick.be\/itenium\/blog\/dotnet\/excel-formulas-cheat-sheet\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/demo.sidekick.be\/itenium\/blog\/dotnet\/excel-formulas-cheat-sheet\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/demo.sidekick.be\/itenium\/wp-content\/uploads\/2025\/11\/excel-math.jpg\",\"datePublished\":\"2018-03-28T16:00:00+00:00\",\"dateModified\":\"2025-11-28T12:31:46+00:00\",\"author\":{\"@id\":\"https:\/\/demo.sidekick.be\/itenium\/#\/schema\/person\/6ab401ce01e858184ee4a8667fe0f022\"},\"breadcrumb\":{\"@id\":\"https:\/\/demo.sidekick.be\/itenium\/blog\/dotnet\/excel-formulas-cheat-sheet\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/demo.sidekick.be\/itenium\/blog\/dotnet\/excel-formulas-cheat-sheet\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/demo.sidekick.be\/itenium\/blog\/dotnet\/excel-formulas-cheat-sheet\/#primaryimage\",\"url\":\"https:\/\/demo.sidekick.be\/itenium\/wp-content\/uploads\/2025\/11\/excel-math.jpg\",\"contentUrl\":\"https:\/\/demo.sidekick.be\/itenium\/wp-content\/uploads\/2025\/11\/excel-math.jpg\",\"width\":360,\"height\":300},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/demo.sidekick.be\/itenium\/blog\/dotnet\/excel-formulas-cheat-sheet\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/demo.sidekick.be\/itenium\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Excel formulas cheat sheet\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/demo.sidekick.be\/itenium\/#website\",\"url\":\"https:\/\/demo.sidekick.be\/itenium\/\",\"name\":\"Itenium\",\"description\":\"We build software. We build careers.\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/demo.sidekick.be\/itenium\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/demo.sidekick.be\/itenium\/#\/schema\/person\/6ab401ce01e858184ee4a8667fe0f022\",\"name\":\"Usdevelop\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/demo.sidekick.be\/itenium\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/cc8cf9b9e9d5bbe7e8d247907cc9ac8457bbfa2854b52eaddf6529adfe88ceab?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/cc8cf9b9e9d5bbe7e8d247907cc9ac8457bbfa2854b52eaddf6529adfe88ceab?s=96&d=mm&r=g\",\"caption\":\"Usdevelop\"},\"sameAs\":[\"https:\/\/demo.sidekick.be\/itenium\"]}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Excel formulas cheat sheet - Itenium","robots":{"index":"noindex","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"og_locale":"en_US","og_type":"article","og_title":"Excel formulas cheat sheet - Itenium","og_description":"Version 4.5.3.3 is the last version of EPPlus you can use without a license for commercial use. See some alternatives if that is a dealbreaker for you!We now have a blog series on an alternative Excel package ClosedXML Which is basically on equal footing with EPPlus.","og_url":"https:\/\/demo.sidekick.be\/itenium\/blog\/dotnet\/excel-formulas-cheat-sheet\/","og_site_name":"Itenium","article_published_time":"2018-03-28T16:00:00+00:00","article_modified_time":"2025-11-28T12:31:46+00:00","og_image":[{"width":360,"height":300,"url":"https:\/\/demo.sidekick.be\/itenium\/wp-content\/uploads\/2025\/11\/excel-math.jpg","type":"image\/jpeg"}],"author":"Usdevelop","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Usdevelop","Est. reading time":"3 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/demo.sidekick.be\/itenium\/blog\/dotnet\/excel-formulas-cheat-sheet\/","url":"https:\/\/demo.sidekick.be\/itenium\/blog\/dotnet\/excel-formulas-cheat-sheet\/","name":"Excel formulas cheat sheet - Itenium","isPartOf":{"@id":"https:\/\/demo.sidekick.be\/itenium\/#website"},"primaryImageOfPage":{"@id":"https:\/\/demo.sidekick.be\/itenium\/blog\/dotnet\/excel-formulas-cheat-sheet\/#primaryimage"},"image":{"@id":"https:\/\/demo.sidekick.be\/itenium\/blog\/dotnet\/excel-formulas-cheat-sheet\/#primaryimage"},"thumbnailUrl":"https:\/\/demo.sidekick.be\/itenium\/wp-content\/uploads\/2025\/11\/excel-math.jpg","datePublished":"2018-03-28T16:00:00+00:00","dateModified":"2025-11-28T12:31:46+00:00","author":{"@id":"https:\/\/demo.sidekick.be\/itenium\/#\/schema\/person\/6ab401ce01e858184ee4a8667fe0f022"},"breadcrumb":{"@id":"https:\/\/demo.sidekick.be\/itenium\/blog\/dotnet\/excel-formulas-cheat-sheet\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/demo.sidekick.be\/itenium\/blog\/dotnet\/excel-formulas-cheat-sheet\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/demo.sidekick.be\/itenium\/blog\/dotnet\/excel-formulas-cheat-sheet\/#primaryimage","url":"https:\/\/demo.sidekick.be\/itenium\/wp-content\/uploads\/2025\/11\/excel-math.jpg","contentUrl":"https:\/\/demo.sidekick.be\/itenium\/wp-content\/uploads\/2025\/11\/excel-math.jpg","width":360,"height":300},{"@type":"BreadcrumbList","@id":"https:\/\/demo.sidekick.be\/itenium\/blog\/dotnet\/excel-formulas-cheat-sheet\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/demo.sidekick.be\/itenium\/"},{"@type":"ListItem","position":2,"name":"Excel formulas cheat sheet"}]},{"@type":"WebSite","@id":"https:\/\/demo.sidekick.be\/itenium\/#website","url":"https:\/\/demo.sidekick.be\/itenium\/","name":"Itenium","description":"We build software. We build careers.","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/demo.sidekick.be\/itenium\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/demo.sidekick.be\/itenium\/#\/schema\/person\/6ab401ce01e858184ee4a8667fe0f022","name":"Usdevelop","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/demo.sidekick.be\/itenium\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/cc8cf9b9e9d5bbe7e8d247907cc9ac8457bbfa2854b52eaddf6529adfe88ceab?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/cc8cf9b9e9d5bbe7e8d247907cc9ac8457bbfa2854b52eaddf6529adfe88ceab?s=96&d=mm&r=g","caption":"Usdevelop"},"sameAs":["https:\/\/demo.sidekick.be\/itenium"]}]}},"_links":{"self":[{"href":"https:\/\/demo.sidekick.be\/itenium\/wp-json\/wp\/v2\/posts\/1654","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/demo.sidekick.be\/itenium\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/demo.sidekick.be\/itenium\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/demo.sidekick.be\/itenium\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/demo.sidekick.be\/itenium\/wp-json\/wp\/v2\/comments?post=1654"}],"version-history":[{"count":3,"href":"https:\/\/demo.sidekick.be\/itenium\/wp-json\/wp\/v2\/posts\/1654\/revisions"}],"predecessor-version":[{"id":2312,"href":"https:\/\/demo.sidekick.be\/itenium\/wp-json\/wp\/v2\/posts\/1654\/revisions\/2312"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/demo.sidekick.be\/itenium\/wp-json\/wp\/v2\/media\/2105"}],"wp:attachment":[{"href":"https:\/\/demo.sidekick.be\/itenium\/wp-json\/wp\/v2\/media?parent=1654"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/demo.sidekick.be\/itenium\/wp-json\/wp\/v2\/categories?post=1654"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/demo.sidekick.be\/itenium\/wp-json\/wp\/v2\/tags?post=1654"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}