excelfunctions.net - information about domain
- Server Status: available
- Server IP: 173.205.127.22
- Server Response Time: 150ms
Site title
Excel Functions and Formulas
Keywords
excel functions,excel formulas,excel function,excel formula,excel functions and formulas,excel formulas and functions,excel formulae,excel spreadsheet formulas
Description
Help with Excel Functions and Formulas - Examples, Tips, Tricks and Common Errors
Alexa information
Alexa rank: 233,791
Rank Trend
Bounce Trend
DNS Information
| Host: | Class: | Type: | IP: | TTL: | Target: | Other: |
| excelfunctions.net | IN | MX | 14400 | excelfunctions.net | ||
| excelfunctions.net | IN | A | 173.205.127.22 | 14400 | ||
| excelfunctions.net | IN | SOA | 86400 | mname: ns1.webhostinghub.com rname: systems-notices.webhostinghub.com serial: 2011020300 refresh: 86400 retry: 7200 expire: 3600000 minimum-ttl: 86400 |
||
| excelfunctions.net | IN | NS | 86400 | ns2.webhostinghub.com | ||
| excelfunctions.net | IN | NS | 86400 | ns1.webhostinghub.com |
Server Location
Site source
Show / hide source
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN"
"http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<!-- Created on 14/09/2008 -->
<html xmlns="http://www.w3.org/1999/xhtml" xml:lang="en" lang="en">
<head>
<title>
Excel Functions and Formulas
</title>
<meta http-equiv="content-type" content="text/html;charset=utf-8" />
<meta http-equiv="last-modified" content="Tue, 31 Jan 2012 23:00:00 GMT" />
<meta http-equiv="Cache-Control" content="max-age=2592000"/>
<meta name="Keywords" content="excel functions,excel formulas,excel function,excel formula,excel functions and formulas,excel formulas and functions,excel formulae,excel spreadsheet formulas" />
<meta name="Description" content="Help with Excel Functions and Formulas - Examples, Tips, Tricks and Common Errors" />
<meta name="robots" content="all" />
<meta http-equiv="content-language" content="en" />
<meta name="revisit-after" content="7 days" />
<meta name="Copyright" content="ExcelFunctions.net" />
<link rel="stylesheet" type="text/css" href="support-files/zmain.css" />
</head>
<body>
<div id="main_outer">
<div class="div1">
<div class="div2">
<div class="div3">
<div class="div4">
<div class="div5">
<div class="div6">
<div class="div7">
<div class="div8">
<div id="main_inner">
<div id="content">
<!-- ******************************************************************************* -->
<!-- ******************** Insert a Logo at the top of the page ********************* -->
<!-- Logo -->
<div style="font-family:'Arial Black',Verdana,Arial,sans-serif; font-size:2.77em; font-style:italic; font-weight:bolder;
position:absolute; left:330px; top:41px;">
ExcelFunctions.net
</div>
<h1>Help with Excel Functions and Formulas</h1>
<!-- the position of the following div is relative to avoid the 'peek-a-boo' bug in IE6 -->
<!-- the right floating div has padding, rather than margins to avoid the IE7 bug -->
<div style="float:right; padding-left:30px; position:relative; top:0; left:0; width:300px;">
<div style="border:1px solid #dddddd; color:#666666; padding:12px 10px; text-align:center;">
If you know the name of the<br />
function you want, select from the<br />
<a href="http://www.excelfunctions.net/excel-functions-alphabetical.html" style="font-weight:bold">
Alphabetical Excel Functions List</a>.
</div>
<div style="border:1px solid #dddddd; margin:10px 0 25px 0; padding:10px 0 0 20px;">
<div style="color:#666666; font-style:italic; font-weight:bold; padding-bottom:10px;">Most Popular Excel Functions</div>
<div style="font-size:0.9em; margin:10px 20px 20px 40px; text-align:left;">
<font style="color:#666666; font-weight:bold;"><b>Text Functions:</b></font>
<div style="margin: 0 0 8px 40px;">
<a href="http://www.excelfunctions.net/FindFunction.html" style="font-weight:bold;">Excel Find Function</a><br />
<a href="http://www.excelfunctions.net/SearchFunction.html" style="font-weight:bold;">Excel Search Function</a>
</div>
<font style="color:#666666; font-weight:bold;"><b>Logical Functions:</b></font>
<div style="margin: 0 0 8px 40px;">
<a href="http://www.excelfunctions.net/ExcelIf.html" style="font-weight:bold;">Excel If Function</a><br />
<a href="http://www.excelfunctions.net/Excel-And-Function.html" style="font-weight:bold;">Excel And Function</a><br />
<a href="http://www.excelfunctions.net/Excel-Or-Function.html" style="font-weight:bold;">Excel Or Function</a>
</div>
<font style="color:#666666; font-weight:bold;"><b>Lookup & Reference Functions:</b></font>
<div style="margin: 0 0 8px 40px;">
<a href="http://www.excelfunctions.net/ExcelVlookup.html" style="font-weight:bold;">Excel Vlookup Function</a><br />
<a href="http://www.excelfunctions.net/ExcelMatch.html" style="font-weight:bold;">Excel Match Function</a>
</div>
<font style="color:#666666; font-weight:bold;"><b>Math & Statistical Functions:</b></font>
<div style="margin: 0 0 12px 40px;">
<a href="http://www.excelfunctions.net/Excel-Sum-Function.html" style="font-weight:bold;">Excel Sum Function</a><br />
<a href="http://www.excelfunctions.net/ExcelSumif.html" style="font-weight:bold;">Excel Sumif Function</a><br />
<a href="http://www.excelfunctions.net/ExcelAverage.html" style="font-weight:bold;">Excel Average Function</a><br />
<a href="http://www.excelfunctions.net/Excel-Count-Function.html" style="font-weight:bold;">Excel Count Function</a><br />
<a href="http://www.excelfunctions.net/ExcelCountif.html" style="font-weight:bold;">Excel Countif Function</a><br />
<a href="http://www.excelfunctions.net/excel-rounding-functions.html" style="font-weight:bold;">Excel Rounding Functions</a><br />
<a href="http://www.excelfunctions.net/standard-deviation-in-excel.html" style="font-weight:bold;">Excel Standard Deviation</a>
</div>
</div>
</div>
</div>
<!-- Google +1 Button Script -->
<!-- Commented out as this fail the w3c validation check -->
<!--
<div style="float:left; padding-top:3px; position:relative; left:0; top:0; width:55px;">
<g:plusone count="false"></g:plusone>
</div>
-->
<div style="margin:15px 0 35px 0; width:380px;">
<!-- ****************** GOOGLE ADSENSE SEARCH CODE **************** -->
<form action="http://www.excelfunctions.net/search.html" id="cse-search-box">
<div>
<input type="hidden" name="cx" value="partner-pub-5138331548304515:shbfjkzhuw3" />
<input type="hidden" name="cof" value="FORID:10" />
<input type="hidden" name="ie" value="ISO-8859-1" />
<input type="text" name="q" size="31" />
<input type="submit" name="sa" value="Search" />
</div>
</form>
<script type="text/javascript" src="http://www.google.com/cse/brand?form=cse-search-box&lang=en"></script>
<!-- ************* END OF GOOGLE ADSENSE SEARCH CODE ************** -->
</div>
<div style="margin:0 0 35px 25px; width:340px;">
<!-- ******* GOOGLE ADSENSE CODE - HOMEP TOP LEFT LARGE RECTANGLE ******* -->
<script type="text/javascript"><!--
google_ad_client = "pub-5138331548304515";
/* 336x280, created 13/09/09 */
google_ad_slot = "2711196392";
google_ad_width = 336;
google_ad_height = 280;
//-->
</script>
<script type="text/javascript"
src="http://pagead2.googlesyndication.com/pagead/show_ads.js">
</script>
<!-- *** END OF GOOGLE ADSENSE CODE - HOMEP TOP LEFT LARGE RECTANGLE *** -->
</div>
<p>
If you have a problem with an Excel function or formula, you have come to the right place!
</p>
<p>
<b>ExcelFunctions.net</b> has been produced to help you to learn all about, and to solve all your
problems with Excel functions and formulas. With the help on this site, you will soon find that
you are confidently using a wide range of Excel formulas and functions, that will transform your
basic spreadsheet into a professional working document that automatically performs all your
calculations - and looks great too!
</p>
<p>
There is a page dedicated to each of Excel's
<a href="http://www.excelfunctions.net/ExcelFunctions.html">Built-In Functions</a>, including
information and examples of how to use the function, tips, and solutions to common errors.
We have also created an
<a href="http://www.excelfunctions.net/Excel-Vlookup-Tutorial.html">Excel Vlookup Tutorial</a>
to assist those who want to learn more about this popular Excel function.
</p>
<p>
Many people use the terms 'Excel Functions' and
<a href="http://www.excelfunctions.net/Excel-Formulas.html">'Excel Formulas'</a> interchangeably,
but the term 'Excel Formulas' (or Excel Formulae) is a wider term, that generally refers any
combination of Excel Functions and/or Operators. Therefore, we have included a separate section
on <a href="http://www.excelfunctions.net/Excel-Formulas.html">Excel Formulas</a>, that provides
examples of how to perform popular tasks using a combination of functions and operators.
There is also a section on
<a href="http://www.excelfunctions.net/Excel-Array-Formulas.html">Excel Array Formulas</a>,
which you need to understand if you want to make full use of some of the most useful Excel functions
and formulas.
</p>
<p>
For beginners, our <a href="http://www.excelfunctions.net/Basic-Excel.html">Basic Excel</a>
pages will give you a strong understanding of the Excel basics, that are needed to enable
you to get the best use from your functions and formulas. There is a section on
<a href="http://www.excelfunctions.net/Excel-Tips.html">Excel Tips and Tricks</a> to help
you to work more efficiently with your spreadsheets, and a section covering
<a href="http://www.excelfunctions.net/Excel-Errors.html">Excel Errors</a> which will help
you to diagnose your error messages and, of course, to fix these errors.
</p>
<p>
The examples on this site use Microsoft Excel 2003, 2007 and 2010.
If you are currently using an older version of Microsoft Office, and would like to learn
more about Microsoft Office 2010, full details are given on the
<a href="http://office.microsoft.com" target="_blank">Microsoft Office Online website</a>.
</p>
<p>
Finally, for those who want to take their skills to the next level, we have included an
<a href="http://www.excelfunctions.net/Writing-Excel-Macros.html">Introductory Guide to Excel Macros</a>
and an <a href="http://www.excelfunctions.net/Excel-VBA-Tutorial.html">Excel VBA Tutorial</a>,
which covers the basics of the VBA programming language in Excel. In this section, we will show
you how to create your own customised Excel function, for those occasions when there is no suitable
built-in function. With practice, writing Excel macros will become a natural part of your spreadsheet
development, enabling you to produce the most professional-looking spreadsheets, that are actually
quite simple to produce ...
</p>
<p>
... once you know how!
</p>
<br />
<div style="text-align:center">
<!-- ********* GOOGLE ADSENSE CODE - HOMEP FOOTER BANNER NO BORDER ********* -->
<script type="text/javascript"><!--
google_ad_client = "pub-5138331548304515";
/* 468x60, created 23/12/09 */
google_ad_slot = "0087503623";
google_ad_width = 468;
google_ad_height = 60;
//-->
</script>
<script type="text/javascript"
src="http://pagead2.googlesyndication.com/pagead/show_ads.js">
</script>
<!-- ****** END OF GOOGLE ADSENSE CODE - HOMEP FOOTER BANNER NO BORDER ****** -->
</div>
</div> <!-- End of content div -->
<div id="navigation">
<!-- Navigation Bar -->
<p class="navbutton"><a href="http://www.excelfunctions.net">Home</a></p>
<p class="navbutton"><a href="http://www.excelfunctions.net/Basic-Excel.html">Basic Excel</a></p>
<p class="navbutton"><a href="http://www.excelfunctions.net/ExcelFunctions.html">Built-In Functions</a></p>
<p class="navbutton2"><a href="http://www.excelfunctions.net/Excel-Text-Functions.html">Text Functions</a></p>
<p class="navbutton2"><a href="http://www.excelfunctions.net/Excel-Logical-Functions.html">Logical Functions</a></p>
<p class="navbutton2"><a href="http://www.excelfunctions.net/Excel-Information-Functions.html">Information Functions</a></p>
<p class="navbutton2"><a href="http://www.excelfunctions.net/Excel-Date-And-Time-Functions.html">Date & Time Functions</a></p>
<p class="navbutton2"><a href="http://www.excelfunctions.net/Excel-Lookup-And-Reference-Functions.html">Lookup & Reference Functions</a></p>
<p class="navbutton2"><a href="http://www.excelfunctions.net/Excel-Math-Functions.html">Math Functions</a></p>
<p class="navbutton2"><a href="http://www.excelfunctions.net/Excel-Statistical-Functions.html">Statistical Functions</a></p>
<p class="navbutton2"><a href="http://www.excelfunctions.net/Excel-Database-Functions.html">Database Functions</a></p>
<p class="navbutton2"><a href="http://www.excelfunctions.net/Excel-Financial-Functions.html">Financial Functions</a></p>
<p class="navbutton2"><a href="http://www.excelfunctions.net/Excel-Engineering-Functions.html">Engineering Functions</a></p>
<p class="navbutton"><a href="http://www.excelfunctions.net/Excel-Vlookup-Tutorial.html">Excel Vlookup Tutorial</a></p>
<p class="navbutton"><a href="http://www.excelfunctions.net/Excel-Pivot-Table-Tutorial.html">Pivot Table Tutorial</a></p>
<p class="navbutton"><a href="http://www.excelfunctions.net/Excel-Formulas.html">Excel Formulas</a></p>
<p class="navbutton"><a href="http://www.excelfunctions.net/Excel-Array-Formulas.html">Array Formulas</a></p>
<p class="navbutton"><a href="http://www.excelfunctions.net/Excel-Tips.html">Tips & Tricks</a></p>
<p class="navbutton"><a href="http://www.excelfunctions.net/Excel-Errors.html">Common Excel Errors</a></p>
<p class="navbutton"><a href="http://www.excelfunctions.net/Excel-Templates.html">Excel Templates</a></p>
<p class="navbutton"><a href="http://www.excelfunctions.net/Writing-Excel-Macros.html">Excel Macros</a></p>
<p class="navbutton"><a href="http://www.excelfunctions.net/Excel-VBA-Tutorial.html">Excel VBA Tutorial</a></p>
<p class="navbutton"><a href="http://www.excelfunctions.net/Excel-2003-vs-Excel-2007.html">Excel 2003 vs 2007</a></p>
<p class="navbutton"><a href="http://www.excelfunctions.net/Excel-Books.html">Recommended Books</a></p>
<p class="navbutton"><a href="http://www.excelfunctions.net/Search-Site.html" rel="nofollow">Search This Site</a></p>
<div style="padding-top:20px; text-align:center;">
<!-- ******* GOOGLE ADSENSE CODE - LEFT MARGIN VERT LINKS STRIP ******** -->
<script type="text/javascript"><!--
google_ad_client = "pub-5138331548304515";
/* 120x90, created 27/12/09 */
google_ad_slot = "9401283004";
google_ad_width = 120;
google_ad_height = 90;
//-->
</script>
<script type="text/javascript"
src="http://pagead2.googlesyndication.com/pagead/show_ads.js">
</script>
<!-- *** END OF GOOGLE ADSENSE CODE - LEFT MARGIN VERT LINKS STRIP *** -->
</div>
</div> <!-- End of navigation div -->
</div> <!-- End of main_inner div -->
</div> <!-- End of div8 -->
</div> <!-- End of div7 -->
</div> <!-- End of div6 -->
</div> <!-- End of div5 -->
</div> <!-- End of div4 -->
</div> <!-- End of div3 -->
</div> <!-- End of div2 -->
</div> <!-- End of div1 -->
<!-- ************************************************************************************************* -->
<!-- ******************************************* Footer ********************************************** -->
<div id="footer">
<!-- Footer -->
<div style="float:left; padding-left:6px">
<!-- **** W3C Markup Validation **** -->
<a href="http://validator.w3.org/check?uri=referer">
<img src="http://www.w3.org/Icons/valid-xhtml10-blue" alt="Valid XHTML 1.0 Transitional" style="border:0; width:88px; height:31px" />
</a>
</div>
<div style="float:left; padding-left:4px;">
<!-- **** W3C CSS Validation **** -->
<a href="http://jigsaw.w3.org/css-validator/check/referer">
<img src="http://jigsaw.w3.org/css-validator/images/vcss-blue" alt="Valid CSS!" style="border:0; width:88px; height:31px" />
</a>
</div>
<div style="float:right; padding-right:10px;">
<a href="http://www.excelfunctions.net/Disclaimer.html" rel="nofollow" style="margin-left:80px; margin-right:20px;">Disclaimer</a>
<a href="http://www.excelfunctions.net/Privacy-Policy.html" rel="nofollow" style="margin-left:20px; margin-right:80px">Privacy Policy</a>
<span style="font-size:0.92em;">Copyright © 2008-2011 ExcelFunctions.net</span>
</div>
</div>
</div> <!-- End of main_outer div -->
<!-- Required for Tracking this Page in Google Analytics -->
<!-- Code for Google Analytics -->
<script type="text/javascript">
var gaJsHost = (("https:" == document.location.protocol) ? "https://ssl." : "http://www.");
document.write(unescape("%3Cscript src='" + gaJsHost + "google-analytics.com/ga.js' type='text/javascript'%3E%3C/script%3E"));
</script>
<script type="text/javascript">
var pageTracker = _gat._getTracker("UA-6192593-1");
pageTracker._trackPageview();
</script>
<!-- Google +1 Button Script -->
<script type="text/javascript" src="https://apis.google.com/js/plusone.js"></script>
</body>
</html>