Mathematical Functions

How to find the percentile if with criteria in Excel

In this article, we will learn How to How to find the percentile value if with given criteria in Excel Scenario: In simple words, when working...

Continue 0 Comment

How to use the FIXED Function in Excel

In this article, we will learn about how to use the FIXED function in Excel. The FIXED function rounds the number to the specified upto decim...

Continue 0 Comment

How to use the DOLLAR Function in Excel

In this article, we will learn about how to use the DOLLAR function in Excel. The DOLLAR function rounds the number to the specified upto dec...

Continue 0 Comment

How to use the FLOOR function in Excel

In this article, we will learn about how to use the FLOOR function in Excel. The FLOOR function rounds down the number to the nearest specified mult...

Continue 0 Comment

How to use the ODD function in Excel

In this article, we will learn how to use ODD Function in Excel. ODD function is a mathematical function which rounds off the given number to the ne...

Continue 0 Comment

How to use the EVEN function in Excel

In this article, we will learn how to use EVEN Function in Excel. EVEN function is a mathematical function which rounds off the given number to the ...

Continue 0 Comment

Average with multiple criteria in Excel

In this article, we will learn how to get the Average with multiple criteria in Excel. Problem? For Instance, We have a large list of data a...

Continue 0 Comment

1
2
3

…

12

Terms and Conditions of use

The applications/code on this site are distributed as is and without warranties or liability. In no event shall the owner of the copyrights, or the authors of the applications/code be liable for any loss of profit, any problems or any damage resulting from the use or evaluation of the applications/code.

@media only screen and ( max-width: 767px ){html body div.wprm-wrapper{overflow:scroll;}#mg-wprm-wrap ul li{border-top:solid 1px rgba(255,255,255,.05);border-bottom:solid 1px rgba(0,0,0,.05);}#wprmenu_bar{background-image:url("");background-size:cover;background-repeat:repeat;}#wprmenu_bar.nitro-lazy{background-image:none !important;}#wprmenu_bar{background-color:#fff;}html body div#mg-wprm-wrap .wpr_submit .icon.icon-search{color:#fff;}#wprmenu_bar .menu_title,#wprmenu_bar .wprmenu_icon_menu{color:#000;}#wprmenu_bar .menu_title{font-size:20px;font-weight:normal;}#mg-wprm-wrap li.menu-item a{font-size:15px;text-transform:uppercase;font-weight:normal;}#mg-wprm-wrap li.menu-item-has-children ul.sub-menu a{font-size:15px;text-transform:uppercase;font-weight:normal;}#mg-wprm-wrap li.current-menu-item > a{background:#3fb7a9;}#mg-wprm-wrap li.current-menu-item > a,#mg-wprm-wrap li.current-menu-item span.wprmenu_icon{color:#fff !important;}#mg-wprm-wrap{background-color:#fff;}.cbp-spmenu-push-toright,.cbp-spmenu-push-toright .mm-slideout{left:80%;}.cbp-spmenu-push-toleft{left:-80%;}#mg-wprm-wrap.cbp-spmenu-right,#mg-wprm-wrap.cbp-spmenu-left,#mg-wprm-wrap.cbp-spmenu-right.custom,#mg-wprm-wrap.cbp-spmenu-left.custom,.cbp-spmenu-vertical{width:80%;max-width:400px;}#mg-wprm-wrap ul#wprmenu_menu_ul li.menu-item a,div#mg-wprm-wrap ul li span.wprmenu_icon{color:#000 !important;}#mg-wprm-wrap ul#wprmenu_menu_ul li.menu-item a:hover{background:#3fb7a9;color:#fff !important;}div#mg-wprm-wrap ul>li:hover>span.wprmenu_icon{color:#fff !important;}.wprmenu_bar .hamburger-inner,.wprmenu_bar .hamburger-inner::before,.wprmenu_bar .hamburger-inner::after{background:#000;}.wprmenu_bar .hamburger:hover .hamburger-inner,.wprmenu_bar .hamburger:hover .hamburger-inner::before,.wprmenu_bar .hamburger:hover .hamburger-inner::after{background:#fff;}div.wprmenu_bar div.hamburger{padding-right:6px !important;}#wprmenu_menu.left{width:80%;left:-80%;right:auto;}#wprmenu_menu.right{width:80%;right:-80%;left:auto;}html body div#wprmenu_bar{height:px;}#mg-wprm-wrap.cbp-spmenu-left,#mg-wprm-wrap.cbp-spmenu-right,#mg-widgetmenu-wrap.cbp-spmenu-widget-left,#mg-widgetmenu-wrap.cbp-spmenu-widget-right{top:px !important;}.wprmenu_bar .hamburger{float:left;}.wprmenu_bar #custom_menu_icon.hamburger{top:0px;left:0px;float:left !important;background-color:#ccc;}.wpr_custom_menu #custom_menu_icon{display:block;}html{padding-top:42px !important;}#wprmenu_bar,#mg-wprm-wrap{display:block;}div#wpadminbar{position:fixed;}}div#wprmenu_bar,div#mg-wprm-wrap{display:none;}table.classsic-custom-tbl{background-color:#fff !important;border:2px solid #000;}table.classsic-custom-tbl tr{color:#000 !important;font-style:italic;}@media (max-width: 767px){div#wprmenu_bar,div#mg-wprm-wrap{display:block;}.top-menu{display:none;}}div#wprmenu_bar,div#mg-wprm-wrap{display:none;}table.classsic-custom-tbl{background-color:#fff !important;border:2px solid #000;}table.classsic-custom-tbl tr{color:#000 !important;font-style:italic;}@media (max-width: 767px){div#wprmenu_bar,div#mg-wprm-wrap{display:block;}.top-menu{display:none;}}