Excel Formula Hacks

div#ez-toc-container p.ez-toc-title{font-size:100%;}div#ez-toc-container p.ez-toc-title{font-weight:700;}div#ez-toc-container ul li{font-size:95%;}div#ez-toc-container{width:75%;}body{background-color:#fff;color:#3a3a3a;}a,a:visited{color:#1e73be;}a:hover,a:focus,a:active{color:#000;}body .grid-container{max-width:1100px;}.wp-block-group__inner-container{max-width:1100px;margin-left:auto;margin-right:auto;}body,button,input,select,textarea{font-family:"Lato",sans-serif;}body{line-height:1.8;}.entry-content > [class*="wp-block-"]:not(:last-child){margin-bottom:1.5em;}.main-title{font-family:"Lato",sans-serif;}.main-navigation .main-nav ul ul li a{font-size:14px;}h1{font-weight:600;}h2{font-weight:600;font-size:36px;line-height:1.4em;}h3{font-weight:600;font-size:30px;line-height:1.4em;}h4{font-weight:600;font-size:26px;line-height:1.4em;}h5{font-weight:600;font-size:22px;line-height:1.4em;}@media (max-width:768px){.main-title{font-size:30px;}h1{font-size:30px;}h2{font-size:25px;}}.top-bar{background-color:#636363;color:#fff;}.top-bar a,.top-bar a:visited{color:#fff;}.top-bar a:hover{color:#303030;}.site-header{background-color:#fff;color:#3a3a3a;}.site-header a,.site-header a:visited{color:#3a3a3a;}.main-title a,.main-title a:hover,.main-title a:visited{color:#222;}.site-description{color:#757575;}.main-navigation,.main-navigation ul ul{background-color:#222;}.main-navigation .main-nav ul li a,.menu-toggle{color:#fff;}.main-navigation .main-nav ul li:hover > a,.main-navigation .main-nav ul li:focus > a,.main-navigation .main-nav ul li.sfHover > a{color:#fff;background-color:#3f3f3f;}button.menu-toggle:hover,button.menu-toggle:focus,.main-navigation .mobile-bar-items a,.main-navigation .mobile-bar-items a:hover,.main-navigation .mobile-bar-items a:focus{color:#fff;}.main-navigation .main-nav ul li[class*="current-menu-"] > a{color:#fff;background-color:#3f3f3f;}.main-navigation .main-nav ul li[class*="current-menu-"] > a:hover,.main-navigation .main-nav ul li[class*="current-menu-"].sfHover > a{color:#fff;background-color:#3f3f3f;}.navigation-search input[type="search"],.navigation-search input[type="search"]:active,.navigation-search input[type="search"]:focus,.main-navigation .main-nav ul li.search-item.active > a{color:#fff;background-color:#3f3f3f;}.main-navigation ul ul{background-color:#3f3f3f;}.main-navigation .main-nav ul ul li a{color:#fff;}.main-navigation .main-nav ul ul li:hover > a,.main-navigation .main-nav ul ul li:focus > a,.main-navigation .main-nav ul ul li.sfHover > a{color:#fff;background-color:#4f4f4f;}.main-navigation .main-nav ul ul li[class*="current-menu-"] > a{color:#fff;background-color:#4f4f4f;}.main-navigation .main-nav ul ul li[class*="current-menu-"] > a:hover,.main-navigation .main-nav ul ul li[class*="current-menu-"].sfHover > a{color:#fff;background-color:#4f4f4f;}.separate-containers .inside-article,.separate-containers .comments-area,.separate-containers .page-header,.one-container .container,.separate-containers .paging-navigation,.inside-page-header{background-color:#fff;}.entry-meta{color:#595959;}.entry-meta a,.entry-meta a:visited{color:#595959;}.entry-meta a:hover{color:#1e73be;}.sidebar .widget{background-color:#fff;}.sidebar .widget .widget-title{color:#000;}.footer-widgets{background-color:#fff;}.footer-widgets .widget-title{color:#000;}.site-info{color:#fff;background-color:#222;}.site-info a,.site-info a:visited{color:#fff;}.site-info a:hover{color:#606060;}.footer-bar .widget_nav_menu .current-menu-item a{color:#606060;}input[type="text"],input[type="email"],input[type="url"],input[type="password"],input[type="search"],input[type="tel"],input[type="number"],textarea,select{color:#666;background-color:#fafafa;border-color:#ccc;}input[type="text"]:focus,input[type="email"]:focus,input[type="url"]:focus,input[type="password"]:focus,input[type="search"]:focus,input[type="tel"]:focus,input[type="number"]:focus,textarea:focus,select:focus{color:#666;background-color:#fff;border-color:#bfbfbf;}button,html input[type="button"],input[type="reset"],input[type="submit"],a.button,a.button:visited,a.wp-block-button__link:not(.has-background){color:#fff;background-color:#666;}button:hover,html input[type="button"]:hover,input[type="reset"]:hover,input[type="submit"]:hover,a.button:hover,button:focus,html input[type="button"]:focus,input[type="reset"]:focus,input[type="submit"]:focus,a.button:focus,a.wp-block-button__link:not(.has-background):active,a.wp-block-button__link:not(.has-background):focus,a.wp-block-button__link:not(.has-background):hover{color:#fff;background-color:#3f3f3f;}.generate-back-to-top,.generate-back-to-top:visited{background-color:rgba(0,0,0,.4);color:#fff;}.generate-back-to-top:hover,.generate-back-to-top:focus{background-color:rgba(0,0,0,.6);color:#fff;}.entry-content .alignwide,body:not(.no-sidebar) .entry-content .alignfull{margin-left:-40px;width:calc(100% + 80px);max-width:calc(100% + 80px);}.rtl .menu-item-has-children .dropdown-menu-toggle{padding-left:20px;}.rtl .main-navigation .main-nav ul li.menu-item-has-children > a{padding-right:20px;}@media (max-width:768px){.separate-containers .inside-article,.separate-containers .comments-area,.separate-containers .page-header,.separate-containers .paging-navigation,.one-container .site-content,.inside-page-header,.wp-block-group__inner-container{padding:30px;}.entry-content .alignwide,body:not(.no-sidebar) .entry-content .alignfull{margin-left:-30px;width:calc(100% + 60px);max-width:calc(100% + 60px);}}.one-container .sidebar .widget{padding:0px;}@media (max-width: 768px){.main-navigation .menu-toggle,.main-navigation .mobile-bar-items,.sidebar-nav-mobile:not(#sticky-placeholder){display:block;}.main-navigation ul,.gen-sidebar-nav{display:none;}[class*="nav-float-"] .site-header .inside-header > *{float:none;clear:both;}}@font-face{font-family:"GeneratePress";src:url("https://v1.nitrocdn.com/zciqOWZgDznkuqFpvIJsLUeyHlJtlHxe/assets/static/source/rev-12ec3cc/wp-content/themes/generatepress/fonts/generatepress.eot");src:url("https://v1.nitrocdn.com/zciqOWZgDznkuqFpvIJsLUeyHlJtlHxe/assets/static/source/rev-12ec3cc/wp-content/themes/generatepress/fonts/generatepress.eot#iefix") format("embedded-opentype"),url("https://v1.nitrocdn.com/zciqOWZgDznkuqFpvIJsLUeyHlJtlHxe/assets/static/source/rev-12ec3cc/wp-content/themes/generatepress/fonts/generatepress.woff2") format("woff2"),url("https://v1.nitrocdn.com/zciqOWZgDznkuqFpvIJsLUeyHlJtlHxe/assets/static/source/rev-12ec3cc/wp-content/themes/generatepress/fonts/generatepress.woff") format("woff"),url("https://v1.nitrocdn.com/zciqOWZgDznkuqFpvIJsLUeyHlJtlHxe/assets/static/source/rev-12ec3cc/wp-content/themes/generatepress/fonts/generatepress.ttf") format("truetype"),url("https://v1.nitrocdn.com/zciqOWZgDznkuqFpvIJsLUeyHlJtlHxe/assets/static/source/rev-12ec3cc/wp-content/themes/generatepress/fonts/generatepress.svg#GeneratePress") format("svg");font-weight:normal;font-style:normal;font-display:swap;}.main-navigation .slideout-toggle a:before,.slide-opened .slideout-overlay .slideout-exit:before{font-family:GeneratePress;}.slideout-navigation .dropdown-menu-toggle:before{content:"" !important;}.slideout-navigation .sfHover > a .dropdown-menu-toggle:before{content:"" !important;}.navigation-branding .main-title{font-weight:bold;text-transform:none;font-size:45px;font-family:"Lato",sans-serif;}@media (max-width: 768px){.navigation-branding .main-title{font-size:30px;}}.ez-toc-title-container{padding-bottom:12px;padding-top:12px;}div#ez-toc-container ul li{line-height:200%;}#ez-toc-container a:visited{color:#444;}#ez-toc-container{margin-top:1em;}li{margin-bottom:20px;margin-top:20px;}.cbyellow,.cbred,.cbgreen,.cbblue{margin:0 0 25px;overflow:hidden;padding:20px;color:#424242;}.cbgreen{background-color:#d9edc2;border-left:5px solid #b2ce96;}.cbred{background-color:#f9dbdb;border-left:5px solid #e9b3b3;}.cbyellow{background-color:#fef5c4;border-left:5px solid #fadf98;}.cbblue{background-color:#e7f2ff;border-left:5px solid #afcde3;}.elementor img{border:2px solid #d5d5d5;margin-bottom:20px;margin-top:20px;}pre{line-height:1.8;}p{margin-top:1.5em;}pre{white-space:pre-wrap;}

Category: Formula Hacks Articles

Count Characters in a Cell (or Range of Cells) Using Formulas in Excel

How to Capitalize First Letter of a Text String in Excel (using Formula & VBA)

#REF! Error in Excel – How to Fix the Reference Error!

How to SUM values between two dates (using SUMIFS formula)

Excel Filter Function – Explained with Examples + Video

Calculate the Number of Months Between Two Dates in Excel (Easy Formulas)

How to Sort by the Last Name in Excel (Easy Guide)

How to Calculate Square Root in Excel (Using Easy Formulas)

Convert Time to Decimal Number in Excel (Hours, Minutes, Seconds)