<?xml version='1.0' encoding='UTF-8'?><?xml-stylesheet href="http://www.blogger.com/styles/atom.css" type="text/css"?><feed xmlns='http://www.w3.org/2005/Atom' xmlns:openSearch='http://a9.com/-/spec/opensearchrss/1.0/' xmlns:blogger='http://schemas.google.com/blogger/2008' xmlns:georss='http://www.georss.org/georss' xmlns:gd="http://schemas.google.com/g/2005" xmlns:thr='http://purl.org/syndication/thread/1.0'><id>tag:blogger.com,1999:blog-8253737087368577623</id><updated>2024-09-04T15:35:12.222+05:00</updated><category term="ABS"/><category term="Absolute Value"/><category term="Trim Mean"/><category term="Trimmean"/><category term="average"/><category term="calculation of npv"/><category term="ceiling"/><category term="creating logics"/><category term="exact matching of cells"/><category term="false logics"/><category term="floor"/><category term="function if"/><category term="hlookup"/><category term="horizontal lookup"/><category term="horizontally lookup a value from a table"/><category term="how to calculate mean"/><category term="if else function"/><category term="logical testing in excel"/><category term="looking up the values with references"/><category term="lookup a value"/><category term="matching the cells in excel"/><category term="matching two cells"/><category term="mean"/><category term="net present value"/><category term="npv"/><category term="npv calculation"/><category term="picking up the strings and values from the text"/><category term="present value"/><category term="rouding down to the nearest multiple"/><category term="rouding the number"/><category term="rounding down the number"/><category term="rounding up to nearest multiple"/><category term="text trimming"/><category term="trim average"/><category term="trimming the text"/><category term="true logics"/><category term="values from left"/><category term="values from middle"/><category term="values from right"/><category term="values from the text"/><category term="values in the text"/><category term="vertical lookup"/><category term="vertically lookup a value in a table"/><category term="vlookup"/><title type='text'>MS EXCEL (SOLUTIONS FOR EXCEL FUNCTIONS)</title><subtitle type='html'></subtitle><link rel='http://schemas.google.com/g/2005#feed' type='application/atom+xml' href='http://excelsols.blogspot.com/feeds/posts/default'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/8253737087368577623/posts/default?redirect=false'/><link rel='alternate' type='text/html' href='http://excelsols.blogspot.com/'/><link rel='hub' href='http://pubsubhubbub.appspot.com/'/><link rel='next' type='application/atom+xml' href='http://www.blogger.com/feeds/8253737087368577623/posts/default?start-index=26&amp;max-results=25&amp;redirect=false'/><author><name>Humayun</name><uri>http://www.blogger.com/profile/04097760079859273206</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='https://img1.blogblog.com/img/b16-rounded.gif'/></author><generator version='7.00' uri='http://www.blogger.com'>Blogger</generator><openSearch:totalResults>31</openSearch:totalResults><openSearch:startIndex>1</openSearch:startIndex><openSearch:itemsPerPage>25</openSearch:itemsPerPage><entry><id>tag:blogger.com,1999:blog-8253737087368577623.post-2961206294217869891</id><published>2012-01-16T20:33:00.002+05:00</published><updated>2012-01-16T20:33:29.244+05:00</updated><category scheme="http://www.blogger.com/atom/ns#" term="calculation of npv"/><category scheme="http://www.blogger.com/atom/ns#" term="net present value"/><category scheme="http://www.blogger.com/atom/ns#" term="npv"/><category scheme="http://www.blogger.com/atom/ns#" term="npv calculation"/><category scheme="http://www.blogger.com/atom/ns#" term="present value"/><title type='text'>FUNCTION NPV (NET PRESENT VALUE)</title><content type='html'>&lt;div dir=&quot;ltr&quot; style=&quot;text-align: left;&quot; trbidi=&quot;on&quot;&gt;&lt;br /&gt;
This function of MS Excel calculates the net present value of an investment by using a discount rate and a series of future payments (negative values) and income (positive values).&lt;br /&gt;
&lt;br /&gt;
How does it work?&lt;br /&gt;
=NPV(rate,value1,[value2],...)&lt;br /&gt;
&lt;br /&gt;
The NPV function syntax has the following arguments (argument: A value that provides information to an action, an event, a method, a property, a function, or a procedure.):&lt;br /&gt;
&lt;br /&gt;
Where:&lt;br /&gt;
&lt;br /&gt;
Rate &amp;nbsp; (Required.) &amp;nbsp;The rate of discount over the length of one period.&lt;br /&gt;
&lt;br /&gt;
Value1, value2, ... &amp;nbsp; &amp;nbsp;Value1 is required, subsequent values are optional. 1 to 254 arguments representing the payments and income.&lt;br /&gt;
&lt;br /&gt;
Value1, value2, ... must be equally spaced in time and occur at the end of each period.&lt;br /&gt;
&lt;br /&gt;
NPV uses the order of value1, value2, ... to interpret the order of cash flows. Be sure to enter your payment and income values in the correct sequence.&lt;br /&gt;
&lt;br /&gt;
Arguments that are empty cells, logical values, or text representations of numbers, error values, or text that cannot be translated into numbers are ignored.&lt;br /&gt;
&lt;br /&gt;
If an argument is an array or reference, only numbers in that array or reference are counted. Empty cells, logical values, text, or error values in the array or reference are ignored.&lt;br /&gt;
&lt;/div&gt;</content><link rel='replies' type='application/atom+xml' href='http://excelsols.blogspot.com/feeds/2961206294217869891/comments/default' title='Post Comments'/><link rel='replies' type='text/html' href='http://excelsols.blogspot.com/2012/01/function-npv-net-present-value.html#comment-form' title='0 Comments'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/8253737087368577623/posts/default/2961206294217869891'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/8253737087368577623/posts/default/2961206294217869891'/><link rel='alternate' type='text/html' href='http://excelsols.blogspot.com/2012/01/function-npv-net-present-value.html' title='FUNCTION NPV (NET PRESENT VALUE)'/><author><name>Humayun</name><uri>http://www.blogger.com/profile/04097760079859273206</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='https://img1.blogblog.com/img/b16-rounded.gif'/></author><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-8253737087368577623.post-8067253909886374429</id><published>2012-01-16T20:23:00.001+05:00</published><updated>2012-01-16T20:26:47.498+05:00</updated><category scheme="http://www.blogger.com/atom/ns#" term="average"/><category scheme="http://www.blogger.com/atom/ns#" term="how to calculate mean"/><category scheme="http://www.blogger.com/atom/ns#" term="mean"/><category scheme="http://www.blogger.com/atom/ns#" term="trim average"/><category scheme="http://www.blogger.com/atom/ns#" term="Trim Mean"/><category scheme="http://www.blogger.com/atom/ns#" term="Trimmean"/><title type='text'>FUNCTION TRIMMEAN</title><content type='html'>&lt;div dir=&quot;ltr&quot; style=&quot;text-align: left;&quot; trbidi=&quot;on&quot;&gt;&lt;br /&gt;
This function returns the mean of the interior of a data set. TRIMMEAN calculates the mean taken by excluding a percentage of data points from the top and bottom tails of a data set. You can use this function when you wish to exclude outlying data from your analysis.&lt;br /&gt;
&lt;br /&gt;
How does it work?&lt;br /&gt;
&lt;br /&gt;
=TRIMMEAN(array, percent)&lt;br /&gt;
&lt;br /&gt;
The TRIMMEAN function syntax has the following arguments (argument: A value that provides information to an action, an event, a method, a property, a function, or a procedure.):&lt;br /&gt;
&lt;br /&gt;
Where:&lt;br /&gt;
&lt;br /&gt;
Array&lt;span class=&quot;Apple-tab-span&quot; style=&quot;white-space: pre;&quot;&gt; &lt;/span&gt;(Required). The array or range of values to trim and average.&lt;br /&gt;
&lt;br /&gt;
Percent&lt;span class=&quot;Apple-tab-span&quot; style=&quot;white-space: pre;&quot;&gt; &lt;/span&gt;(Required). The fractional number of data points to exclude from the calculation.&lt;br /&gt;
&lt;br /&gt;
For example, if percent = 0.2, 4 points are trimmed from a data set of 20 points (20 x 0.2): 2 from the top and 2 from the bottom of the set.&lt;br /&gt;
&lt;br /&gt;
Remarks&lt;br /&gt;
&lt;br /&gt;
If percent &amp;lt; 0 or percent &amp;gt; 1, TRIMMEAN returns the #NUM! error value. So, the percentage value should be in between 0 &amp;amp; 1.&lt;br /&gt;
&lt;br /&gt;
TRIMMEAN rounds the number of excluded data points down to the nearest multiple of 2. If percent = 0.1, 10 percent of 30 data points equals 3 points. For symmetry, TRIMMEAN excludes a single value from the top and bottom of the data set.&lt;/div&gt;</content><link rel='replies' type='application/atom+xml' href='http://excelsols.blogspot.com/feeds/8067253909886374429/comments/default' title='Post Comments'/><link rel='replies' type='text/html' href='http://excelsols.blogspot.com/2012/01/function-trimmean.html#comment-form' title='0 Comments'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/8253737087368577623/posts/default/8067253909886374429'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/8253737087368577623/posts/default/8067253909886374429'/><link rel='alternate' type='text/html' href='http://excelsols.blogspot.com/2012/01/function-trimmean.html' title='FUNCTION TRIMMEAN'/><author><name>Humayun</name><uri>http://www.blogger.com/profile/04097760079859273206</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='https://img1.blogblog.com/img/b16-rounded.gif'/></author><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-8253737087368577623.post-5006475555568283034</id><published>2011-06-10T20:27:00.001+05:00</published><updated>2011-06-10T20:28:05.486+05:00</updated><title type='text'>FUNCTION DAYS360</title><content type='html'>This function returns the number of days between two dates based on a 360-day year (twelve 30-day months), which is used in some accounting calculations. Use this function to help compute payments if your accounting system is based on twelve 30-day months.&lt;br /&gt;
&lt;br /&gt;
How does it work?&lt;br /&gt;
&lt;br /&gt;
=DAYS360(start_date,end_date,method)&lt;br /&gt;
&lt;br /&gt;
Where&lt;br /&gt;
&lt;br /&gt;
Start_date &amp; end_date are the two dates between which you want to know the number of days. If start_date occurs after end_date, DAYS360 returns a negative number. Dates should be entered by using the DATE function, or as results of other formulas or functions. For example, use DATE(2008,5,23) for the 23rd day of May, 2008. Problems can occur if dates are entered as text.&lt;br /&gt;
&lt;br /&gt;
Method   is a logical value that specifies whether to use the U.S. or European method in the calculation.&lt;br /&gt;
&lt;br /&gt;
FALSE or omitted&lt;br /&gt;
U.S. (NASD) method. If the starting date is the last day of a month, it becomes equal to the 30th of the same month. If the ending date is the last day of a month and the starting date is earlier than the 30th of a month, the ending date becomes equal to the 1st of the next month; otherwise the ending date becomes equal to the 30th of the same month. &lt;br /&gt;
&lt;br /&gt;
TRUE&lt;br /&gt;
European method. Starting dates and ending dates that occur on the 31st of a month become equal to the 30th of the same month. &lt;br /&gt;
&lt;br /&gt;
Remark&lt;br /&gt;
Microsoft Excel stores dates as sequential serial numbers so they can be used in calculations. By default, January 1, 1900 is serial number 1, and January 1, 2008 is serial number 39448 because it is 39,448 days after January 1, 1900. Microsoft Excel for the Macintosh uses a different date system as its default.</content><link rel='replies' type='application/atom+xml' href='http://excelsols.blogspot.com/feeds/5006475555568283034/comments/default' title='Post Comments'/><link rel='replies' type='text/html' href='http://excelsols.blogspot.com/2011/06/function-days360.html#comment-form' title='0 Comments'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/8253737087368577623/posts/default/5006475555568283034'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/8253737087368577623/posts/default/5006475555568283034'/><link rel='alternate' type='text/html' href='http://excelsols.blogspot.com/2011/06/function-days360.html' title='FUNCTION DAYS360'/><author><name>Humayun</name><uri>http://www.blogger.com/profile/04097760079859273206</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='https://img1.blogblog.com/img/b16-rounded.gif'/></author><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-8253737087368577623.post-6012778312504225222</id><published>2011-03-28T20:46:00.000+05:00</published><updated>2011-03-28T20:46:07.950+05:00</updated><title type='text'>FUNCTION FREQUENCY</title><content type='html'>This function calculates how often values occur within a range of values, and then returns a vertical array of numbers. &lt;br /&gt;
&lt;br /&gt;
For example, use FREQUENCY to count the number of test scores that fall within ranges of scores. Because FREQUENCY returns an array, it must be entered as an array formula.&lt;br /&gt;
&lt;br /&gt;
How does it work?&lt;br /&gt;
&lt;br /&gt;
=FREQUENCY(data_array,bins_array)&lt;br /&gt;
&lt;br /&gt;
Where ...&lt;br /&gt;
&lt;br /&gt;
Data_array   is an array of or reference to a set of values for which you want to count frequencies. If data_array contains no values, FREQUENCY returns an array of zeros.&lt;br /&gt;
&lt;br /&gt;
Bins_array   is an array of or reference to intervals into which you want to group the values in data_array. If bins_array contains no values, FREQUENCY returns the number of elements in data_array.&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
Remarks&lt;br /&gt;
&lt;br /&gt;
- FREQUENCY is entered as an array formula after you select a range of adjacent cells into which you want the returned distribution to appear. &lt;br /&gt;
&lt;br /&gt;
- The number of elements in the returned array is one more than the number of elements in bins_array. The extra element in the returned array returns the count of any values above the highest interval. For example, when counting three ranges of values (intervals) that are entered into three cells, be sure to enter FREQUENCY into four cells for the results. The extra cell returns the number of values in data_array that are greater than the third interval value. &lt;br /&gt;
&lt;br /&gt;
- FREQUENCY ignores blank cells and text. &lt;br /&gt;
&lt;br /&gt;
- Formulas that return arrays must be entered as array formulas.</content><link rel='replies' type='application/atom+xml' href='http://excelsols.blogspot.com/feeds/6012778312504225222/comments/default' title='Post Comments'/><link rel='replies' type='text/html' href='http://excelsols.blogspot.com/2011/03/function-frequency.html#comment-form' title='0 Comments'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/8253737087368577623/posts/default/6012778312504225222'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/8253737087368577623/posts/default/6012778312504225222'/><link rel='alternate' type='text/html' href='http://excelsols.blogspot.com/2011/03/function-frequency.html' title='FUNCTION FREQUENCY'/><author><name>Humayun</name><uri>http://www.blogger.com/profile/04097760079859273206</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='https://img1.blogblog.com/img/b16-rounded.gif'/></author><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-8253737087368577623.post-6124432213093039709</id><published>2011-03-28T20:38:00.000+05:00</published><updated>2011-03-28T20:38:21.693+05:00</updated><title type='text'>FUNCTION CORREL</title><content type='html'>This function returns the correlation coefficient of the array1 and array2 cell ranges. Use the correlation coefficient to determine the relationship between two properties.&lt;br /&gt;
&lt;br /&gt;
For example, you can examine the relationship between a location&#39;s average temperature and the use of air conditioners.&lt;br /&gt;
&lt;br /&gt;
How does it work?&lt;br /&gt;
&lt;br /&gt;
=CORREL(array1,array2)&lt;br /&gt;
&lt;br /&gt;
Where...&lt;br /&gt;
&lt;br /&gt;
Array1   is a cell range of values.&lt;br /&gt;
&lt;br /&gt;
Array2   is a second cell range of values.</content><link rel='replies' type='application/atom+xml' href='http://excelsols.blogspot.com/feeds/6124432213093039709/comments/default' title='Post Comments'/><link rel='replies' type='text/html' href='http://excelsols.blogspot.com/2011/03/function-correl.html#comment-form' title='0 Comments'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/8253737087368577623/posts/default/6124432213093039709'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/8253737087368577623/posts/default/6124432213093039709'/><link rel='alternate' type='text/html' href='http://excelsols.blogspot.com/2011/03/function-correl.html' title='FUNCTION CORREL'/><author><name>Humayun</name><uri>http://www.blogger.com/profile/04097760079859273206</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='https://img1.blogblog.com/img/b16-rounded.gif'/></author><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-8253737087368577623.post-2921303026246684270</id><published>2011-03-08T21:29:00.000+05:00</published><updated>2011-03-08T21:29:26.953+05:00</updated><title type='text'>FUNCTION SPELLNUMBER</title><content type='html'>This function is used to spell the numbers in words in MS Excel. Follow these four steps and then use this function. This function can also be used to Print Checks by MS Excel. Just make a template for Check and use this function to spell the amount automatically.  &lt;br /&gt;
&lt;br /&gt;
Step 1...Start Microsoft Excel.&lt;br /&gt;
Step 2...Press ALT+F11 to start the Visual Basic Editor.&lt;br /&gt;
Step 3...On the Insert menu, click Module.&lt;br /&gt;
Step 4...Type the following code into the module sheet. (from Option Explicit... to End Function)&lt;br /&gt;
-----------------------------------------------&lt;br /&gt;
Option Explicit&lt;br /&gt;
&#39;Main Function&lt;br /&gt;
Function SpellNumber(ByVal MyNumber)&lt;br /&gt;
    Dim Dollars, Cents, Temp&lt;br /&gt;
    Dim DecimalPlace, Count&lt;br /&gt;
    ReDim Place(9) As String&lt;br /&gt;
    Place(2) = &quot; Thousand &quot;&lt;br /&gt;
    Place(3) = &quot; Million &quot;&lt;br /&gt;
    Place(4) = &quot; Billion &quot;&lt;br /&gt;
    Place(5) = &quot; Trillion &quot;&lt;br /&gt;
    &#39; String representation of amount.&lt;br /&gt;
    MyNumber = Trim(Str(MyNumber))&lt;br /&gt;
    &#39; Position of decimal place 0 if none.&lt;br /&gt;
    DecimalPlace = InStr(MyNumber, &quot;.&quot;)&lt;br /&gt;
    &#39; Convert cents and set MyNumber to dollar amount.&lt;br /&gt;
    If DecimalPlace &gt; 0 Then&lt;br /&gt;
        Cents = GetTens(Left(Mid(MyNumber, DecimalPlace + 1) &amp; _&lt;br /&gt;
                  &quot;00&quot;, 2))&lt;br /&gt;
        MyNumber = Trim(Left(MyNumber, DecimalPlace - 1))&lt;br /&gt;
    End If&lt;br /&gt;
    Count = 1&lt;br /&gt;
    Do While MyNumber &lt;&gt; &quot;&quot;&lt;br /&gt;
        Temp = GetHundreds(Right(MyNumber, 3))&lt;br /&gt;
        If Temp &lt;&gt; &quot;&quot; Then Dollars = Temp &amp; Place(Count) &amp; Dollars&lt;br /&gt;
        If Len(MyNumber) &gt; 3 Then&lt;br /&gt;
            MyNumber = Left(MyNumber, Len(MyNumber) - 3)&lt;br /&gt;
        Else&lt;br /&gt;
            MyNumber = &quot;&quot;&lt;br /&gt;
        End If&lt;br /&gt;
        Count = Count + 1&lt;br /&gt;
    Loop&lt;br /&gt;
    Select Case Dollars&lt;br /&gt;
        Case &quot;&quot;&lt;br /&gt;
            Dollars = &quot;No Dollars&quot;&lt;br /&gt;
        Case &quot;One&quot;&lt;br /&gt;
            Dollars = &quot;One Dollar&quot;&lt;br /&gt;
         Case Else&lt;br /&gt;
            Dollars = Dollars &amp; &quot; Dollars&quot;&lt;br /&gt;
    End Select&lt;br /&gt;
    Select Case Cents&lt;br /&gt;
        Case &quot;&quot;&lt;br /&gt;
            Cents = &quot; and No Cents&quot;&lt;br /&gt;
        Case &quot;One&quot;&lt;br /&gt;
            Cents = &quot; and One Cent&quot;&lt;br /&gt;
              Case Else&lt;br /&gt;
            Cents = &quot; and &quot; &amp; Cents &amp; &quot; Cents&quot;&lt;br /&gt;
    End Select&lt;br /&gt;
    SpellNumber = Dollars &amp; Cents&lt;br /&gt;
End Function&lt;br /&gt;
      &lt;br /&gt;
&#39; Converts a number from 100-999 into text &lt;br /&gt;
Function GetHundreds(ByVal MyNumber)&lt;br /&gt;
    Dim Result As String&lt;br /&gt;
    If Val(MyNumber) = 0 Then Exit Function&lt;br /&gt;
    MyNumber = Right(&quot;000&quot; &amp; MyNumber, 3)&lt;br /&gt;
    &#39; Convert the hundreds place.&lt;br /&gt;
    If Mid(MyNumber, 1, 1) &lt;&gt; &quot;0&quot; Then&lt;br /&gt;
        Result = GetDigit(Mid(MyNumber, 1, 1)) &amp; &quot; Hundred &quot;&lt;br /&gt;
    End If&lt;br /&gt;
    &#39; Convert the tens and ones place.&lt;br /&gt;
    If Mid(MyNumber, 2, 1) &lt;&gt; &quot;0&quot; Then&lt;br /&gt;
        Result = Result &amp; GetTens(Mid(MyNumber, 2))&lt;br /&gt;
    Else&lt;br /&gt;
        Result = Result &amp; GetDigit(Mid(MyNumber, 3))&lt;br /&gt;
    End If&lt;br /&gt;
    GetHundreds = Result&lt;br /&gt;
End Function&lt;br /&gt;
      &lt;br /&gt;
&#39; Converts a number from 10 to 99 into text. &lt;br /&gt;
Function GetTens(TensText)&lt;br /&gt;
    Dim Result As String&lt;br /&gt;
    Result = &quot;&quot;           &#39; Null out the temporary function value.&lt;br /&gt;
    If Val(Left(TensText, 1)) = 1 Then   &#39; If value between 10-19...&lt;br /&gt;
        Select Case Val(TensText)&lt;br /&gt;
            Case 10: Result = &quot;Ten&quot;&lt;br /&gt;
            Case 11: Result = &quot;Eleven&quot;&lt;br /&gt;
            Case 12: Result = &quot;Twelve&quot;&lt;br /&gt;
            Case 13: Result = &quot;Thirteen&quot;&lt;br /&gt;
            Case 14: Result = &quot;Fourteen&quot;&lt;br /&gt;
            Case 15: Result = &quot;Fifteen&quot;&lt;br /&gt;
            Case 16: Result = &quot;Sixteen&quot;&lt;br /&gt;
            Case 17: Result = &quot;Seventeen&quot;&lt;br /&gt;
            Case 18: Result = &quot;Eighteen&quot;&lt;br /&gt;
            Case 19: Result = &quot;Nineteen&quot;&lt;br /&gt;
            Case Else&lt;br /&gt;
        End Select&lt;br /&gt;
    Else                                 &#39; If value between 20-99...&lt;br /&gt;
        Select Case Val(Left(TensText, 1))&lt;br /&gt;
            Case 2: Result = &quot;Twenty &quot;&lt;br /&gt;
            Case 3: Result = &quot;Thirty &quot;&lt;br /&gt;
            Case 4: Result = &quot;Forty &quot;&lt;br /&gt;
            Case 5: Result = &quot;Fifty &quot;&lt;br /&gt;
            Case 6: Result = &quot;Sixty &quot;&lt;br /&gt;
            Case 7: Result = &quot;Seventy &quot;&lt;br /&gt;
            Case 8: Result = &quot;Eighty &quot;&lt;br /&gt;
            Case 9: Result = &quot;Ninety &quot;&lt;br /&gt;
            Case Else&lt;br /&gt;
        End Select&lt;br /&gt;
        Result = Result &amp; GetDigit _&lt;br /&gt;
            (Right(TensText, 1))  &#39; Retrieve ones place.&lt;br /&gt;
    End If&lt;br /&gt;
    GetTens = Result&lt;br /&gt;
End Function&lt;br /&gt;
     &lt;br /&gt;
&#39; Converts a number from 1 to 9 into text. &lt;br /&gt;
Function GetDigit(Digit)&lt;br /&gt;
    Select Case Val(Digit)&lt;br /&gt;
        Case 1: GetDigit = &quot;One&quot;&lt;br /&gt;
        Case 2: GetDigit = &quot;Two&quot;&lt;br /&gt;
        Case 3: GetDigit = &quot;Three&quot;&lt;br /&gt;
        Case 4: GetDigit = &quot;Four&quot;&lt;br /&gt;
        Case 5: GetDigit = &quot;Five&quot;&lt;br /&gt;
        Case 6: GetDigit = &quot;Six&quot;&lt;br /&gt;
        Case 7: GetDigit = &quot;Seven&quot;&lt;br /&gt;
        Case 8: GetDigit = &quot;Eight&quot;&lt;br /&gt;
        Case 9: GetDigit = &quot;Nine&quot;&lt;br /&gt;
        Case Else: GetDigit = &quot;&quot;&lt;br /&gt;
    End Select&lt;br /&gt;
End Function&lt;br /&gt;
-----------------------------------------------&lt;br /&gt;
&lt;br /&gt;
After saving, close the Script Window and goto the Excel Spreadsheet. now insert the following function.&lt;br /&gt;
&lt;br /&gt;
=SpellNumber(Cell_Reference)&lt;br /&gt;
&lt;br /&gt;
Note&lt;br /&gt;
&lt;br /&gt;
Cell Reference may also be the value itself you want to spell in words.</content><link rel='replies' type='application/atom+xml' href='http://excelsols.blogspot.com/feeds/2921303026246684270/comments/default' title='Post Comments'/><link rel='replies' type='text/html' href='http://excelsols.blogspot.com/2011/03/function-spellnumber.html#comment-form' title='0 Comments'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/8253737087368577623/posts/default/2921303026246684270'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/8253737087368577623/posts/default/2921303026246684270'/><link rel='alternate' type='text/html' href='http://excelsols.blogspot.com/2011/03/function-spellnumber.html' title='FUNCTION SPELLNUMBER'/><author><name>Humayun</name><uri>http://www.blogger.com/profile/04097760079859273206</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='https://img1.blogblog.com/img/b16-rounded.gif'/></author><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-8253737087368577623.post-742194028204800699</id><published>2011-03-08T20:44:00.000+05:00</published><updated>2011-03-08T20:44:07.965+05:00</updated><title type='text'>FUNCTION GROWTH</title><content type='html'>Growth&lt;br /&gt;
&lt;br /&gt;
This function calculates predicted exponential growth by using existing data. GROWTH returns the y-values for a series of new x-values that you specify by using existing x-values and y-values. You can also use the GROWTH worksheet function to fit an exponential curve to existing x-values and y-values.&lt;br /&gt;
&lt;br /&gt;
How does it work?&lt;br /&gt;
&lt;br /&gt;
=GROWTH(known_y&#39;s,known_x&#39;s,new_x&#39;s,const)&lt;br /&gt;
&lt;br /&gt;
where:&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
Known_y&#39;s   is the set of y-values you already know in the relationship y = b*m^x.&lt;br /&gt;
&lt;br /&gt;
- If the array known_y&#39;s is in a single column, then each column of known_x&#39;s is interpreted as a separate variable.&lt;br /&gt;
&lt;br /&gt;
- If the array known_y&#39;s is in a single row, then each row of known_x&#39;s is interpreted as a separate variable.&lt;br /&gt;
&lt;br /&gt;
- If any of the numbers in known_y&#39;s is 0 or negative, GROWTH returns the #NUM! error value.&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
Known_x&#39;s   is an optional set of x-values that you may already know in the relationship y = b*m^x.&lt;br /&gt;
&lt;br /&gt;
- The array known_x&#39;s can include one or more sets of variables. If only one variable is used, known_y&#39;s and known_x&#39;s can be ranges of any shape, as long as they have equal dimensions. If more than one variable is used, known_y&#39;s must be a vector (that is, a range with a height of one row or a width of one column).&lt;br /&gt;
&lt;br /&gt;
- If known_x&#39;s is omitted, it is assumed to be the array {1,2,3,...} that is the same size as known_y&#39;s.&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
New_x&#39;s   are new x-values for which you want GROWTH to return corresponding y-values.&lt;br /&gt;
&lt;br /&gt;
- New_x&#39;s must include a column (or row) for each independent variable, just as known_x&#39;s does. So, if known_y&#39;s is in a single column, known_x&#39;s and new_x&#39;s must have the same number of columns. If known_y&#39;s is in a single row, known_x&#39;s and new_x&#39;s must have the same number of rows.&lt;br /&gt;
&lt;br /&gt;
- If new_x&#39;s is omitted, it is assumed to be the same as known_x&#39;s.&lt;br /&gt;
&lt;br /&gt;
- If both known_x&#39;s and new_x&#39;s are omitted, they are assumed to be the array {1,2,3,...} that is the same size as known_y&#39;s.&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
Const   is a logical value specifying whether to force the constant b to equal 1.&lt;br /&gt;
&lt;br /&gt;
- If const is TRUE or omitted, b is calculated normally.&lt;br /&gt;
&lt;br /&gt;
- If const is FALSE, b is set equal to 1 and the m-values are adjusted so that y = m^x.&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
Remarks&lt;br /&gt;
&lt;br /&gt;
- Formulas that return arrays must be entered as array formulas after selecting the correct number of cells. &lt;br /&gt;
&lt;br /&gt;
- When entering an array constant for an argument such as known_x&#39;s, use commas to separate values in the same row and semicolons to separate rows.</content><link rel='replies' type='application/atom+xml' href='http://excelsols.blogspot.com/feeds/742194028204800699/comments/default' title='Post Comments'/><link rel='replies' type='text/html' href='http://excelsols.blogspot.com/2011/03/function-growth.html#comment-form' title='0 Comments'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/8253737087368577623/posts/default/742194028204800699'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/8253737087368577623/posts/default/742194028204800699'/><link rel='alternate' type='text/html' href='http://excelsols.blogspot.com/2011/03/function-growth.html' title='FUNCTION GROWTH'/><author><name>Humayun</name><uri>http://www.blogger.com/profile/04097760079859273206</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='https://img1.blogblog.com/img/b16-rounded.gif'/></author><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-8253737087368577623.post-911760788689272600</id><published>2011-02-13T16:22:00.002+05:00</published><updated>2011-02-13T16:22:11.193+05:00</updated><title type='text'>FUNCTION GEOMEAN (GEOMETRIC MEAN)</title><content type='html'>GEOMEAN (GEOMETRIC MEAN)&lt;br /&gt;
&lt;br /&gt;
This function returns the geometric mean of an array or range of positive data. For example, you can use GEOMEAN to calculate average growth rate given compound interest with variable rates.&lt;br /&gt;
&lt;br /&gt;
How does it work?&lt;br /&gt;
&lt;br /&gt;
=GEOMEAN(number1,number2,...)&lt;br /&gt;
&lt;br /&gt;
Number1, number2, ...   are 1 to 255 arguments for which you want to calculate the mean. You can also use a single array or a reference to an array instead of arguments separated by commas.</content><link rel='replies' type='application/atom+xml' href='http://excelsols.blogspot.com/feeds/911760788689272600/comments/default' title='Post Comments'/><link rel='replies' type='text/html' href='http://excelsols.blogspot.com/2011/02/function-geomean-geometric-mean.html#comment-form' title='0 Comments'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/8253737087368577623/posts/default/911760788689272600'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/8253737087368577623/posts/default/911760788689272600'/><link rel='alternate' type='text/html' href='http://excelsols.blogspot.com/2011/02/function-geomean-geometric-mean.html' title='FUNCTION GEOMEAN (GEOMETRIC MEAN)'/><author><name>Humayun</name><uri>http://www.blogger.com/profile/04097760079859273206</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='https://img1.blogblog.com/img/b16-rounded.gif'/></author><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-8253737087368577623.post-6171709065266980427</id><published>2011-02-13T16:20:00.001+05:00</published><updated>2011-02-13T16:22:48.856+05:00</updated><title type='text'>FUNCTION HARMEAN (HARMONIC MEAN)</title><content type='html'>HARMEAN (HARMONIC MEAN)&lt;br /&gt;
&lt;br /&gt;
This function returns the harmonic mean of a data set. The harmonic mean is the reciprocal of the arithmetic mean of reciprocals.&lt;br /&gt;
&lt;br /&gt;
How does it work?&lt;br /&gt;
&lt;br /&gt;
=HARMEAN(number1,number2,...)&lt;br /&gt;
&lt;br /&gt;
Number1, number2, ...   are 1 to 255 arguments for which you want to calculate the mean. You can also use a single array or a reference to an array instead of arguments separated by commas.</content><link rel='replies' type='application/atom+xml' href='http://excelsols.blogspot.com/feeds/6171709065266980427/comments/default' title='Post Comments'/><link rel='replies' type='text/html' href='http://excelsols.blogspot.com/2011/02/function-harmean-harmonic-mean.html#comment-form' title='0 Comments'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/8253737087368577623/posts/default/6171709065266980427'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/8253737087368577623/posts/default/6171709065266980427'/><link rel='alternate' type='text/html' href='http://excelsols.blogspot.com/2011/02/function-harmean-harmonic-mean.html' title='FUNCTION HARMEAN (HARMONIC MEAN)'/><author><name>Humayun</name><uri>http://www.blogger.com/profile/04097760079859273206</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='https://img1.blogblog.com/img/b16-rounded.gif'/></author><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-8253737087368577623.post-3400603670062446212</id><published>2011-02-13T16:08:00.002+05:00</published><updated>2011-02-13T16:08:56.023+05:00</updated><title type='text'>FUNCTION TRANSPOSE</title><content type='html'>Transpose&lt;br /&gt;
&lt;br /&gt;
This function returns a vertical range of cells as a horizontal range, or vice versa. TRANSPOSE must be entered as an array formula (array formula: A formula that performs multiple calculations on one or more sets of values, and then returns either a single result or multiple results. Array formulas are enclosed between braces { } and are entered by pressing CTRL+SHIFT+ENTER.) in a range that has the same number of rows and columns, respectively, as an array (array: Used to build single formulas that produce multiple results or that operate on a group of arguments that are arranged in rows and columns. An array range shares a common formula; an array constant is a group of constants used as an argument.) has columns and rows. Use TRANSPOSE to shift the vertical and horizontal orientation of an array on a worksheet.&lt;br /&gt;
&lt;br /&gt;
How does it work?&lt;br /&gt;
&lt;br /&gt;
=TRANSPOSE(array)&lt;br /&gt;
&lt;br /&gt;
Array   is an array or range of cells on a worksheet that you want to transpose. The transpose of an array is created by using the first row of the array as the first column of the new array, the second row of the array as the second column of the new array, and so on.</content><link rel='replies' type='application/atom+xml' href='http://excelsols.blogspot.com/feeds/3400603670062446212/comments/default' title='Post Comments'/><link rel='replies' type='text/html' href='http://excelsols.blogspot.com/2011/02/function-transpose.html#comment-form' title='0 Comments'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/8253737087368577623/posts/default/3400603670062446212'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/8253737087368577623/posts/default/3400603670062446212'/><link rel='alternate' type='text/html' href='http://excelsols.blogspot.com/2011/02/function-transpose.html' title='FUNCTION TRANSPOSE'/><author><name>Humayun</name><uri>http://www.blogger.com/profile/04097760079859273206</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='https://img1.blogblog.com/img/b16-rounded.gif'/></author><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-8253737087368577623.post-6191601775191478812</id><published>2011-02-13T16:06:00.001+05:00</published><updated>2011-02-13T16:09:49.556+05:00</updated><title type='text'>FUNCTION CONFIDENCE</title><content type='html'>Confidence&lt;br /&gt;
&lt;br /&gt;
This function returns a value that you can use to construct a confidence interval for a population mean. The confidence interval is a range of values. Your sample mean, x, is at the center of this range and the range is x ± CONFIDENCE. For example, if x is the sample mean of delivery times for products ordered through the mail, x ± CONFIDENCE is a range of population means. For any population mean, μ0, in this range, the probability of obtaining a sample mean further from μ0 than x is greater than alpha; for any population mean, μ0, not in this range, the probability of obtaining a sample mean further from μ0 than x is less than alpha. In other words, assume that we use x, standard_dev, and size to construct a two-tailed test at significance level alpha of the hypothesis that the population mean is μ0. Then we will not reject that hypothesis if μ0 is in the confidence interval and will reject that hypothesis if μ0 is not in the confidence interval. The confidence interval does not allow us to infer that there is probability 1 – alpha that our next package will take a delivery time that is in the confidence interval.&lt;br /&gt;
&lt;br /&gt;
How does it work?&lt;br /&gt;
&lt;br /&gt;
=CONFIDENCE(alpha,standard_dev,size)&lt;br /&gt;
&lt;br /&gt;
Alpha   is the significance level used to compute the confidence level. The confidence level equals 100*(1 - alpha)%, or in other words, an alpha of 0.05 indicates a 95 percent confidence level.&lt;br /&gt;
&lt;br /&gt;
Standard_dev   is the population standard deviation for the data range and is assumed to be known.&lt;br /&gt;
&lt;br /&gt;
Size   is the sample size.</content><link rel='replies' type='application/atom+xml' href='http://excelsols.blogspot.com/feeds/6191601775191478812/comments/default' title='Post Comments'/><link rel='replies' type='text/html' href='http://excelsols.blogspot.com/2011/02/function-confidence.html#comment-form' title='0 Comments'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/8253737087368577623/posts/default/6191601775191478812'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/8253737087368577623/posts/default/6191601775191478812'/><link rel='alternate' type='text/html' href='http://excelsols.blogspot.com/2011/02/function-confidence.html' title='FUNCTION CONFIDENCE'/><author><name>Humayun</name><uri>http://www.blogger.com/profile/04097760079859273206</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='https://img1.blogblog.com/img/b16-rounded.gif'/></author><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-8253737087368577623.post-891279584961749632</id><published>2011-02-09T10:07:00.001+05:00</published><updated>2011-02-09T10:07:52.995+05:00</updated><title type='text'>FUNCTION AVERAGE</title><content type='html'>Average&lt;br /&gt;
&lt;br /&gt;
This function returns the average (arithmetic mean) of the given data or the given range of data.&lt;br /&gt;
&lt;br /&gt;
How does it work?&lt;br /&gt;
&lt;br /&gt;
=AVERAGE(number1,number2,...)&lt;br /&gt;
&lt;br /&gt;
Number1, number2, ...   are 1 to 255 numeric arguments for which you want the average.&lt;br /&gt;
&lt;br /&gt;
Remarks&lt;br /&gt;
&lt;br /&gt;
Arguments can either be numbers or names, arrays, or references that contain numbers. &lt;br /&gt;
Logical values and text representations of numbers that you type directly into the list of arguments are counted.&lt;br /&gt;
&lt;br /&gt;
If an array or reference argument contains text, logical values, or empty cells, those values are ignored; however, cells with the value zero are included. &lt;br /&gt;
&lt;br /&gt;
Arguments that are error values or text that cannot be translated into numbers cause errors.&lt;br /&gt;
If you want to include logical values and text representations of numbers in a reference as part of the calculation, use the AVERAGEA function.&lt;br /&gt;
&lt;br /&gt;
 Note    The AVERAGE function measures central tendency, which is the location of the center of a group of numbers in a statistical distribution. The three most common measures of central tendency are:&lt;br /&gt;
&lt;br /&gt;
Average   which is the arithmetic mean, and is calculated by adding a group of numbers and then dividing by the count of those numbers. For example, the average of 2, 3, 3, 5, 7, and 10 is 30 divided by 6, which is 5. &lt;br /&gt;
&lt;br /&gt;
Median   which is the middle number of a group of numbers; that is, half the numbers have values that are greater than the median, and half the numbers have values that are less than the median. For example, the median of 2, 3, 3, 5, 7, and 10 is 4.&lt;br /&gt;
&lt;br /&gt;
Mode   which is the most frequently occurring number in a group of numbers. For example, the mode of 2, 3, 3, 5, 7, and 10 is 3.&lt;br /&gt;
&lt;br /&gt;
For a symmetrical distribution of a group of numbers, these three measures of central tendency are all the same. For a skewed distribution of a group of numbers, they can be different.&lt;br /&gt;
&lt;br /&gt;
Tip  When averaging cells, keep in mind the difference between empty cells and those containing the value zero, especially if you have cleared the Show a zero in cells that have a zero value check box in the Working with Office Applications section of the Advanced category on the Excel Options dialog box under the File menu. Empty cells are not counted, but zero values are.</content><link rel='replies' type='application/atom+xml' href='http://excelsols.blogspot.com/feeds/891279584961749632/comments/default' title='Post Comments'/><link rel='replies' type='text/html' href='http://excelsols.blogspot.com/2011/02/function-average.html#comment-form' title='0 Comments'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/8253737087368577623/posts/default/891279584961749632'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/8253737087368577623/posts/default/891279584961749632'/><link rel='alternate' type='text/html' href='http://excelsols.blogspot.com/2011/02/function-average.html' title='FUNCTION AVERAGE'/><author><name>Humayun</name><uri>http://www.blogger.com/profile/04097760079859273206</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='https://img1.blogblog.com/img/b16-rounded.gif'/></author><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-8253737087368577623.post-1875404995782570503</id><published>2011-02-07T14:33:00.001+05:00</published><updated>2011-02-13T16:37:39.447+05:00</updated><title type='text'>FUNCTION REPT (REPEAT)</title><content type='html'>REPT (REPEAT)&lt;br /&gt;
&lt;br /&gt;
This function repeats text a given number of times. Use REPT to fill a cell with a number of instances of a text string.&lt;br /&gt;
&lt;br /&gt;
How does it work?&lt;br /&gt;
&lt;br /&gt;
=REPT(text,number_times)&lt;br /&gt;
&lt;br /&gt;
Where&lt;br /&gt;
&lt;br /&gt;
Text   is the text you want to repeat. This may include the text itself in inverted commas or the cell reference where the text lies.&lt;br /&gt;
&lt;br /&gt;
Number_times   is a positive number specifying the number of times you want to repeat text.&lt;br /&gt;
&lt;br /&gt;
Remarks&lt;br /&gt;
&lt;br /&gt;
If number_times is 0 (zero), REPT returns &quot;&quot; (empty text). &lt;br /&gt;
If number_times is not an integer, it is truncated. &lt;br /&gt;
The result of the REPT function cannot be longer than 32,767 characters, or REPT returns #VALUE!.</content><link rel='replies' type='application/atom+xml' href='http://excelsols.blogspot.com/feeds/1875404995782570503/comments/default' title='Post Comments'/><link rel='replies' type='text/html' href='http://excelsols.blogspot.com/2011/02/function-rept-repeat.html#comment-form' title='0 Comments'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/8253737087368577623/posts/default/1875404995782570503'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/8253737087368577623/posts/default/1875404995782570503'/><link rel='alternate' type='text/html' href='http://excelsols.blogspot.com/2011/02/function-rept-repeat.html' title='FUNCTION REPT (REPEAT)'/><author><name>Humayun</name><uri>http://www.blogger.com/profile/04097760079859273206</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='https://img1.blogblog.com/img/b16-rounded.gif'/></author><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-8253737087368577623.post-1361594175179122005</id><published>2011-02-04T10:26:00.002+05:00</published><updated>2011-02-07T14:35:55.366+05:00</updated><title type='text'>FUNCTION LEN</title><content type='html'>LEN&lt;br /&gt;
&lt;br /&gt;
This function returns the number of characters in a text string.&lt;br /&gt;
&lt;br /&gt;
This function always counts each character, whether single-byte or double-byte, as 1, no matter what the default language setting is.&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
How does it work?&lt;br /&gt;
&lt;br /&gt;
=LEN(text)&lt;br /&gt;
&lt;br /&gt;
Text   is the text itself in inverted commas or the cell reference of the text whose length you want to find. Spaces count as characters.</content><link rel='replies' type='application/atom+xml' href='http://excelsols.blogspot.com/feeds/1361594175179122005/comments/default' title='Post Comments'/><link rel='replies' type='text/html' href='http://excelsols.blogspot.com/2011/02/function-len.html#comment-form' title='0 Comments'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/8253737087368577623/posts/default/1361594175179122005'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/8253737087368577623/posts/default/1361594175179122005'/><link rel='alternate' type='text/html' href='http://excelsols.blogspot.com/2011/02/function-len.html' title='FUNCTION LEN'/><author><name>Humayun</name><uri>http://www.blogger.com/profile/04097760079859273206</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='https://img1.blogblog.com/img/b16-rounded.gif'/></author><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-8253737087368577623.post-6087856998124748077</id><published>2009-10-31T10:02:00.001+06:00</published><updated>2009-10-31T10:04:46.690+06:00</updated><title type='text'>FUNCTION FORECAST</title><content type='html'>FORECAST&lt;br /&gt;
&lt;br /&gt;
This function calculates, or predicts, a future value by using existing values. The predicted value is a y-value for a given x-value. The known values are existing x-values and y-values, and the new value is predicted by using linear regression. You can use this function to predict future sales, inventory requirements, or consumer trends.&lt;br /&gt;
&lt;br /&gt;
How does it work?&lt;br /&gt;
&lt;br /&gt;
=FORECAST(x,known_y&#39;s,known_x&#39;s)&lt;br /&gt;
&lt;br /&gt;
Where:&lt;br /&gt;
&lt;br /&gt;
X    is the data point for which you want to predict a value.&lt;br /&gt;
&lt;br /&gt;
KNOWN_Y&#39;S    is the dependent array or range of data.&lt;br /&gt;
&lt;br /&gt;
KNOWN_X&#39;S    is the independent array or range of data.&lt;br /&gt;
&lt;br /&gt;
Remarks&lt;br /&gt;
&lt;br /&gt;
- If x is nonnumeric, FORECAST returns the #VALUE! error value. &lt;br /&gt;
- If known_y&#39;s and known_x&#39;s are empty or contain a different number of data points, FORECAST returns the #N/A error value. &lt;br /&gt;
- If the variance of known_x&#39;s equals zero, then FORECAST returns the #DIV/0! error value. &lt;br /&gt;
- The equation for FORECAST is y=a+bx.</content><link rel='replies' type='application/atom+xml' href='http://excelsols.blogspot.com/feeds/6087856998124748077/comments/default' title='Post Comments'/><link rel='replies' type='text/html' href='http://excelsols.blogspot.com/2009/10/forecast-this-function-calculates-or.html#comment-form' title='0 Comments'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/8253737087368577623/posts/default/6087856998124748077'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/8253737087368577623/posts/default/6087856998124748077'/><link rel='alternate' type='text/html' href='http://excelsols.blogspot.com/2009/10/forecast-this-function-calculates-or.html' title='FUNCTION FORECAST'/><author><name>Humayun</name><uri>http://www.blogger.com/profile/04097760079859273206</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='https://img1.blogblog.com/img/b16-rounded.gif'/></author><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-8253737087368577623.post-4988030448409109854</id><published>2009-10-31T09:54:00.001+06:00</published><updated>2011-02-13T15:35:22.394+05:00</updated><title type='text'>FUNCTION COMBIN (COMBINATION)</title><content type='html'>COMBIN&lt;br /&gt;
&lt;br /&gt;
This function returns the number of combination for a given number of items. Use &quot;COMBIN&quot; to determine the total possible number of groups for a given number of items.&lt;br /&gt;
&lt;br /&gt;
How does it work?&lt;br /&gt;
&lt;br /&gt;
=COMBIN(number,number_chosen)&lt;br /&gt;
&lt;br /&gt;
Where:&lt;br /&gt;
&lt;br /&gt;
NUMBER is the number of items.&lt;br /&gt;
&lt;br /&gt;
NUMBER_CHOSEN is the number of items in each combination.&lt;br /&gt;
&lt;br /&gt;
Remarks&lt;br /&gt;
&lt;br /&gt;
- Numeric arguments are truncated to integers. &lt;br /&gt;
- If either argument is nonnumeric, COMBIN returns the #VALUE! error value. &lt;br /&gt;
- If number &lt; 0, number_chosen &lt; 0, or number &lt; number_chosen, COMBIN returns the #NUM! error value. &lt;br /&gt;
- A combination is any set or subset of items, regardless of their internal order. - Combinations are distinct from permutations, for which the internal order is significant.</content><link rel='replies' type='application/atom+xml' href='http://excelsols.blogspot.com/feeds/4988030448409109854/comments/default' title='Post Comments'/><link rel='replies' type='text/html' href='http://excelsols.blogspot.com/2009/10/function-conbin-combination.html#comment-form' title='0 Comments'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/8253737087368577623/posts/default/4988030448409109854'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/8253737087368577623/posts/default/4988030448409109854'/><link rel='alternate' type='text/html' href='http://excelsols.blogspot.com/2009/10/function-conbin-combination.html' title='FUNCTION COMBIN (COMBINATION)'/><author><name>Humayun</name><uri>http://www.blogger.com/profile/04097760079859273206</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='https://img1.blogblog.com/img/b16-rounded.gif'/></author><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-8253737087368577623.post-7513461501733578480</id><published>2009-10-31T09:51:00.001+06:00</published><updated>2009-10-31T09:55:05.749+06:00</updated><title type='text'>FUNCTION PERMUT (PERMUTATION)</title><content type='html'>PERMUT&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
This function returns the number of permutations for a given number of objects that can be selected from number objects. A permutation is any set or subset of objects or events where internal order is significant. Permutations are different from combination, for which the internal order is not significant. Use this function for lottery-style probability calculations.&lt;br /&gt;
&lt;br /&gt;
How does it work?&lt;br /&gt;
&lt;br /&gt;
=PERMUT(number,number_chosen)&lt;br /&gt;
&lt;br /&gt;
Where:&lt;br /&gt;
&lt;br /&gt;
NUMBER    is an integer that describes the number of objects.&lt;br /&gt;
&lt;br /&gt;
NUMBER_CHOSEN    is an integer that describes the number of objects in each permutation.&lt;br /&gt;
&lt;br /&gt;
Remarks&lt;br /&gt;
&lt;br /&gt;
- Both arguments are truncated to integers. &lt;br /&gt;
- If number or number_chosen is nonnumeric, PERMUT returns the #VALUE! error value. &lt;br /&gt;
- If number ≤ 0 or if number_chosen &lt; 0, PERMUT returns the #NUM! error value. &lt;br /&gt;
- If number &lt; number_chosen, PERMUT returns the #NUM! error value.</content><link rel='replies' type='application/atom+xml' href='http://excelsols.blogspot.com/feeds/7513461501733578480/comments/default' title='Post Comments'/><link rel='replies' type='text/html' href='http://excelsols.blogspot.com/2009/10/function-permut-permutation.html#comment-form' title='0 Comments'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/8253737087368577623/posts/default/7513461501733578480'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/8253737087368577623/posts/default/7513461501733578480'/><link rel='alternate' type='text/html' href='http://excelsols.blogspot.com/2009/10/function-permut-permutation.html' title='FUNCTION PERMUT (PERMUTATION)'/><author><name>Humayun</name><uri>http://www.blogger.com/profile/04097760079859273206</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='https://img1.blogblog.com/img/b16-rounded.gif'/></author><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-8253737087368577623.post-8674583393290624984</id><published>2009-10-31T09:48:00.000+06:00</published><updated>2009-10-31T09:48:27.688+06:00</updated><title type='text'>FUNCTION SUMIF</title><content type='html'>SUMIF&lt;br /&gt;
&lt;br /&gt;
This function adds the cells specified by a given criteria.&lt;br /&gt;
&lt;br /&gt;
How does it work?&lt;br /&gt;
&lt;br /&gt;
=SUMIF(range,criteria,sum_range)&lt;br /&gt;
&lt;br /&gt;
Where:&lt;br /&gt;
&lt;br /&gt;
RANGE    is the range of cells you want evaluated.&lt;br /&gt;
&lt;br /&gt;
CRITERIA    is the criteria in the form of a number, expression, or text that defines which cells will be added. For example, criteria can be expressed as 32, &quot;32&quot;, &quot;&gt;32&quot;, &quot;apples&quot;.&lt;br /&gt;
&lt;br /&gt;
SUM_RANGE    are the actual cells to sum.&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
Remarks&lt;br /&gt;
&lt;br /&gt;
- The cells in sum_range are summed only if their corresponding cells in range match the criteria.&lt;br /&gt;
&lt;br /&gt;
- If sum_range is omitted, the cells in range are summed.</content><link rel='replies' type='application/atom+xml' href='http://excelsols.blogspot.com/feeds/8674583393290624984/comments/default' title='Post Comments'/><link rel='replies' type='text/html' href='http://excelsols.blogspot.com/2009/10/function-sumif.html#comment-form' title='0 Comments'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/8253737087368577623/posts/default/8674583393290624984'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/8253737087368577623/posts/default/8674583393290624984'/><link rel='alternate' type='text/html' href='http://excelsols.blogspot.com/2009/10/function-sumif.html' title='FUNCTION SUMIF'/><author><name>Humayun</name><uri>http://www.blogger.com/profile/04097760079859273206</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='https://img1.blogblog.com/img/b16-rounded.gif'/></author><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-8253737087368577623.post-7888699308182562589</id><published>2009-10-31T09:34:00.001+06:00</published><updated>2009-10-31T09:43:30.812+06:00</updated><title type='text'>FUNCTION FV &amp; PV (FUTURE VALUE &amp; PRESENT VALUE)</title><content type='html'>FV (FUTURE VALUE)&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
This function returns the future value of an investment based on periodic, constant payments and a constant interest rate.&lt;br /&gt;
&lt;br /&gt;
How does it work?&lt;br /&gt;
&lt;br /&gt;
=FV(rate,nper,pmt,pv,type)&lt;br /&gt;
&lt;br /&gt;
Where:&lt;br /&gt;
&lt;br /&gt;
RATE is the interest rate per period.&lt;br /&gt;
&lt;br /&gt;
NPER is the total number of payment periods in an annuity.&lt;br /&gt;
&lt;br /&gt;
PMT is the payment made each period; it cannot change over the life of the annuity. Typically, pmt contains principal and interest but no other fees or taxes. If pmt is omitted, you must include the pv argument.&lt;br /&gt;
&lt;br /&gt;
PV is the present value, or the lump-sum amount that a series of future payments is worth right now. If pv is omitted, it is assumed to be 0 (zero), and you must include the pmt argument.&lt;br /&gt;
&lt;br /&gt;
TYPE is the number 0 or 1 and indicates when payments are due. If type is omitted, it is assumed to be 0.&lt;br /&gt;
&lt;br /&gt;
- Set type equal to 0, If payments are due at the end of the period and,&lt;br /&gt;
- Set type equal to 1, If payments are due at the beginning of the period&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
Remarks&lt;br /&gt;
&lt;br /&gt;
- Make sure that you are consistent about the units you use for specifying rate and nper. If you make monthly payments on a four-year loan at 12 percent annual interest, use 12%/12 for rate and 4*12 for nper. If you make annual payments on the same loan, use 12% for rate and 4 for nper. &lt;br /&gt;
&lt;br /&gt;
- For all the arguments, cash you pay out, such as deposits to savings, is represented by negative numbers; cash you receive, such as dividend checks, is represented by positive numbers. &lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
PV (PRESENT VALUE)&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
This function returns the present value of an investment. The present value is the total amount that a series of future payments is worth now. For example, when you borrow money, the loan amount is the present value to the lender.&lt;br /&gt;
&lt;br /&gt;
How does it work?&lt;br /&gt;
&lt;br /&gt;
=PV(rate,nper,pmt,fv,type)&lt;br /&gt;
&lt;br /&gt;
Where:&lt;br /&gt;
&lt;br /&gt;
RATE is the interest rate per period. For example, if you obtain an automobile loan at a 10 percent annual interest rate and make monthly payments, your interest rate per month is 10%/12, or 0.83%. You would enter 10%/12, or 0.83%, or 0.0083, into the formula as the rate.&lt;br /&gt;
&lt;br /&gt;
NPER    is the total number of payment periods in an annuity. For example, if you get a four-year car loan and make monthly payments, your loan has 4*12 (or 48) periods. You would enter 48 into the formula for nper.&lt;br /&gt;
&lt;br /&gt;
PMT    is the payment made each period and cannot change over the life of the annuity. Typically, pmt includes principal and interest but no other fees or taxes. For example, the monthly payments on a $10,000, four-year car loan at 12 percent are $263.33. You would enter -263.33 into the formula as the pmt. If pmt is omitted, you must include the fv argument.&lt;br /&gt;
&lt;br /&gt;
FV    is the future value, or a cash balance you want to attain after the last payment is made. If fv is omitted, it is assumed to be 0 (the future value of a loan, for example, is 0). For example, if you want to save $50,000 to pay for a special project in 18 years, then $50,000 is the future value. You could then make a conservative guess at an interest rate and determine how much you must save each month. If fv is omitted, you must include the pmt argument.&lt;br /&gt;
&lt;br /&gt;
TYPE    is the number 0 or 1 and indicates when payments are due.&lt;br /&gt;
&lt;br /&gt;
- Set type equal to &quot;0 or omitted&quot;, If payments are due at the end of the period and,&lt;br /&gt;
- Set type equal to &quot;1&quot;, If payments are due at the beginning of the period&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
Remarks &lt;br /&gt;
&lt;br /&gt;
- Make sure that you are consistent about the units you use for specifying rate and nper. If you make monthly payments on a four-year loan at 12 percent annual interest, use 12%/12 for rate and 4*12 for nper. If you make annual payments on the same loan, use 12% for rate and 4 for nper. &lt;br /&gt;
&lt;br /&gt;
- The following functions apply to annuities:&lt;br /&gt;
&lt;br /&gt;
 CUMIPMT&lt;br /&gt;
 PPMT&lt;br /&gt;
 CUMPRINC    &lt;br /&gt;
 PV&lt;br /&gt;
 FV          &lt;br /&gt;
 RATE&lt;br /&gt;
 FVSCHEDULE  &lt;br /&gt;
 XIRR&lt;br /&gt;
 IPMT        &lt;br /&gt;
 XNPV&lt;br /&gt;
 PMT   &lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
- An annuity is a series of constant cash payments made over a continuous period. For example, a car loan or a mortgage is an annuity. For more information, see the description for each annuity function. &lt;br /&gt;
&lt;br /&gt;
- In annuity functions, cash you pay out, such as a deposit to savings, is represented by a negative number; cash you receive, such as a dividend check, is represented by a positive number. For example, a $1,000 deposit to the bank would be represented by the argument -1000 if you are the depositor and by the argument 1000 if you are the bank. &lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
Note&lt;br /&gt;
&lt;br /&gt;
The interest rate is divided by 12 to get a monthly rate. The years the money is paid out is multiplied by 12 to get the number of payments.</content><link rel='replies' type='application/atom+xml' href='http://excelsols.blogspot.com/feeds/7888699308182562589/comments/default' title='Post Comments'/><link rel='replies' type='text/html' href='http://excelsols.blogspot.com/2009/10/function-fv-pv-future-value-present.html#comment-form' title='0 Comments'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/8253737087368577623/posts/default/7888699308182562589'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/8253737087368577623/posts/default/7888699308182562589'/><link rel='alternate' type='text/html' href='http://excelsols.blogspot.com/2009/10/function-fv-pv-future-value-present.html' title='FUNCTION FV &amp; PV (FUTURE VALUE &amp; PRESENT VALUE)'/><author><name>Humayun</name><uri>http://www.blogger.com/profile/04097760079859273206</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='https://img1.blogblog.com/img/b16-rounded.gif'/></author><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-8253737087368577623.post-59999287471755430</id><published>2009-10-27T11:19:00.001+06:00</published><updated>2009-10-27T11:19:24.255+06:00</updated><title type='text'>FUNCTION DOLLAR</title><content type='html'>This function converts a number to text format and applies a currency symbol up to specified decimal points. The name of the function (and the symbol that it applies) depends upon your language settings.&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
How does it work?&lt;br /&gt;
&lt;br /&gt;
=DOLLAR(number,decimals)&lt;br /&gt;
&lt;br /&gt;
Where:&lt;br /&gt;
&quot;Number&quot; is a number, a reference to a cell containing a number, or a formula that evaluates to a number.&lt;br /&gt;
and &quot;Decimals&quot; is the number of digits to the right of the decimal point. If decimals is negative, number is rounded to the left of the decimal point. If you omit decimals, it is assumed to be 2.&lt;br /&gt;
&lt;br /&gt;
Remarks&lt;br /&gt;
&lt;br /&gt;
The major difference between formatting a cell that contains a number with the Cells command (Format menu) and formatting a number directly with the DOLLAR function is that DOLLAR converts its result to text. A number formatted with the Cells command is still a number. You can continue to use numbers formatted with DOLLAR in formulas, because Microsoft Excel converts numbers entered as text values to numbers when it calculates.</content><link rel='replies' type='application/atom+xml' href='http://excelsols.blogspot.com/feeds/59999287471755430/comments/default' title='Post Comments'/><link rel='replies' type='text/html' href='http://excelsols.blogspot.com/2009/10/function-dollar.html#comment-form' title='0 Comments'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/8253737087368577623/posts/default/59999287471755430'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/8253737087368577623/posts/default/59999287471755430'/><link rel='alternate' type='text/html' href='http://excelsols.blogspot.com/2009/10/function-dollar.html' title='FUNCTION DOLLAR'/><author><name>Humayun</name><uri>http://www.blogger.com/profile/04097760079859273206</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='https://img1.blogblog.com/img/b16-rounded.gif'/></author><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-8253737087368577623.post-5125488135118911882</id><published>2009-09-30T13:07:00.000+06:00</published><updated>2009-09-30T13:07:46.161+06:00</updated><title type='text'>FUNCTION INTERCEPT &amp; SLOPE (Calculating Alpha &amp; Beta)</title><content type='html'>INTERCEPT (Calculating ALPHA)&lt;br /&gt;
&lt;br /&gt;
This function calculates the point at which a line will intersect the y-axis by using existing x-values and y-values. The intercept point is based on a best-fit regression line plotted through the known x-values and known y-values. Use the INTERCEPT function when you want to determine the value of the dependent variable when the independent variable is 0 (zero). For example, you can use the INTERCEPT function to predict a metal&#39;s electrical resistance at 0°C when your data points were taken at room temperature and higher.&lt;br /&gt;
&lt;br /&gt;
In Statistics this is known as calculating alpha “α”&lt;br /&gt;
&lt;br /&gt;
How does it work?&lt;br /&gt;
&lt;br /&gt;
=INTERCEPT(known_y&#39;s,known_x&#39;s)&lt;br /&gt;
Where…&lt;br /&gt;
Known_y&#39;s    is the dependent set of observations or data.&lt;br /&gt;
Known_x&#39;s    is the independent set of observations or data.&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
Remarks&lt;br /&gt;
&lt;br /&gt;
- The arguments should be either numbers or names, arrays, or references that contain numbers. &lt;br /&gt;
&lt;br /&gt;
- If an array or reference argument contains text, logical values, or empty cells, those values are ignored; however, cells with the value zero are included. &lt;br /&gt;
&lt;br /&gt;
- If known_y&#39;s and known_x&#39;s contain a different number of data points or contain no data points, INTERCEPT returns the #N/A error value. &lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
SLOPE (Calculating BETA)&lt;br /&gt;
&lt;br /&gt;
This function returns the slope of the linear regression line through data points in known_y&#39;s and known_x&#39;s. The slope is the vertical distance divided by the horizontal distance between any two points on the line, which is the rate of change along the regression line.&lt;br /&gt;
&lt;br /&gt;
In Statistics this is known as calculating beta “β”&lt;br /&gt;
&lt;br /&gt;
How does it work?&lt;br /&gt;
&lt;br /&gt;
=SLOPE(known_y&#39;s,known_x&#39;s)&lt;br /&gt;
Where…&lt;br /&gt;
Known_y&#39;s    is an array or cell range of numeric dependent data points.&lt;br /&gt;
Known_x&#39;s    is the set of independent data points.&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
Remarks&lt;br /&gt;
&lt;br /&gt;
- The arguments must be either numbers or names, arrays, or references that contain numbers. &lt;br /&gt;
&lt;br /&gt;
- If an array or reference argument contains text, logical values, or empty cells, those values are ignored; however, cells with the value zero are included. &lt;br /&gt;
&lt;br /&gt;
- If known_y&#39;s and known_x&#39;s are empty or have a different number of data points, SLOPE returns the #N/A error value.</content><link rel='replies' type='application/atom+xml' href='http://excelsols.blogspot.com/feeds/5125488135118911882/comments/default' title='Post Comments'/><link rel='replies' type='text/html' href='http://excelsols.blogspot.com/2009/09/function-intercept-slope-calculating.html#comment-form' title='0 Comments'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/8253737087368577623/posts/default/5125488135118911882'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/8253737087368577623/posts/default/5125488135118911882'/><link rel='alternate' type='text/html' href='http://excelsols.blogspot.com/2009/09/function-intercept-slope-calculating.html' title='FUNCTION INTERCEPT &amp; SLOPE (Calculating Alpha &amp; Beta)'/><author><name>Humayun</name><uri>http://www.blogger.com/profile/04097760079859273206</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='https://img1.blogblog.com/img/b16-rounded.gif'/></author><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-8253737087368577623.post-1792579789284010717</id><published>2009-09-08T12:48:00.000+06:00</published><updated>2009-09-08T12:48:59.738+06:00</updated><title type='text'>FUNCTION EVEN, ODD</title><content type='html'>EVEN&lt;br /&gt;
 &lt;br /&gt;
This function returns number rounded up to the nearest even integer. You can use this function for processing items that come in twos. For example, a packing crate accepts rows of one or two items. The crate is full when the number of items, rounded up to the nearest two, matches the crate&#39;s capacity.&lt;br /&gt;
&lt;br /&gt;
How does it work?&lt;br /&gt;
&lt;br /&gt;
=EVEN(number)&lt;br /&gt;
&lt;br /&gt;
Number    is the value to round.&lt;br /&gt;
&lt;br /&gt;
Remarks&lt;br /&gt;
&lt;br /&gt;
If number is nonnumeric, EVEN returns the #VALUE! error value. &lt;br /&gt;
Regardless of the sign of number, a value is rounded up when adjusted away from zero. If number is an even integer, no rounding occurs.&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
ODD&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
Returns number rounded up to the nearest odd integer.&lt;br /&gt;
&lt;br /&gt;
How does it work?&lt;br /&gt;
&lt;br /&gt;
=ODD(number)&lt;br /&gt;
&lt;br /&gt;
Number   is the value to round.&lt;br /&gt;
&lt;br /&gt;
Remarks&lt;br /&gt;
&lt;br /&gt;
If number is nonnumeric, ODD returns the #VALUE! error value. &lt;br /&gt;
Regardless of the sign of number, a value is rounded up when adjusted away from zero. If number is an odd integer, no rounding occurs.</content><link rel='replies' type='application/atom+xml' href='http://excelsols.blogspot.com/feeds/1792579789284010717/comments/default' title='Post Comments'/><link rel='replies' type='text/html' href='http://excelsols.blogspot.com/2009/09/function-even-odd.html#comment-form' title='0 Comments'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/8253737087368577623/posts/default/1792579789284010717'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/8253737087368577623/posts/default/1792579789284010717'/><link rel='alternate' type='text/html' href='http://excelsols.blogspot.com/2009/09/function-even-odd.html' title='FUNCTION EVEN, ODD'/><author><name>Humayun</name><uri>http://www.blogger.com/profile/04097760079859273206</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='https://img1.blogblog.com/img/b16-rounded.gif'/></author><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-8253737087368577623.post-1065950769456708661</id><published>2009-08-31T12:18:00.004+06:00</published><updated>2009-08-31T12:21:28.184+06:00</updated><title type='text'>FUNCTION AND</title><content type='html'>This function returns TRUE if all its arguments are TRUE; returns FALSE if one or more argument is FALSE.&lt;br /&gt;&lt;br /&gt;How does it work?&lt;br /&gt;&lt;br /&gt;AND(logical1,logical2, ...)&lt;br /&gt;&lt;br /&gt;You can use up to 30 conditions to test that can be either TRUE or FALSE.&lt;br /&gt;&lt;br /&gt;- The arguments must evaluate to logical values such as TRUE or FALSE, or the arguments must be arrays (array: Used to build single formulas that produce multiple results or that operate on a group of arguments that are arranged in rows and columns. An array range shares a common formula; an array constant is a group of constants used as an argument.) or references that contain logical values. &lt;br /&gt;&lt;br /&gt;- If an array or reference argument contains text or empty cells, those values are ignored. &lt;br /&gt;&lt;br /&gt;- If the specified range contains no logical values, AND returns the #VALUE! error value.</content><link rel='replies' type='application/atom+xml' href='http://excelsols.blogspot.com/feeds/1065950769456708661/comments/default' title='Post Comments'/><link rel='replies' type='text/html' href='http://excelsols.blogspot.com/2009/08/function-and.html#comment-form' title='0 Comments'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/8253737087368577623/posts/default/1065950769456708661'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/8253737087368577623/posts/default/1065950769456708661'/><link rel='alternate' type='text/html' href='http://excelsols.blogspot.com/2009/08/function-and.html' title='FUNCTION AND'/><author><name>Humayun</name><uri>http://www.blogger.com/profile/04097760079859273206</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='https://img1.blogblog.com/img/b16-rounded.gif'/></author><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-8253737087368577623.post-7602538692775149529</id><published>2009-07-24T10:37:00.001+06:00</published><updated>2012-02-17T16:34:21.014+05:00</updated><category scheme="http://www.blogger.com/atom/ns#" term="hlookup"/><category scheme="http://www.blogger.com/atom/ns#" term="horizontal lookup"/><category scheme="http://www.blogger.com/atom/ns#" term="horizontally lookup a value from a table"/><category scheme="http://www.blogger.com/atom/ns#" term="looking up the values with references"/><category scheme="http://www.blogger.com/atom/ns#" term="lookup a value"/><category scheme="http://www.blogger.com/atom/ns#" term="vertical lookup"/><category scheme="http://www.blogger.com/atom/ns#" term="vertically lookup a value in a table"/><category scheme="http://www.blogger.com/atom/ns#" term="vlookup"/><title type='text'>FUNCTION VLOOKUP &amp; HLOOKUP</title><content type='html'>&lt;div dir=&quot;ltr&quot; style=&quot;text-align: left;&quot; trbidi=&quot;on&quot;&gt;VLOOKUP&lt;br /&gt;
&lt;br /&gt;
This function searches for a value in the leftmost column of a table, and then returns a value in the same row from a column you specify in the table. Use VLOOKUP instead of HLOOKUP when your comparison values are located in a column to the left of the data you want to find.&lt;br /&gt;
&lt;br /&gt;
The V in VLOOKUP stands for &quot;Vertical.&quot;&lt;br /&gt;
&lt;br /&gt;
How does it work?&lt;br /&gt;
&lt;br /&gt;
VLOOKUP(lookup_value,table_array,col_index_num,range_lookup)&lt;br /&gt;
&lt;br /&gt;
Lookup_value    is the value to be found in the first column of the array. Lookup_value can be a value, a reference, or a text string.&lt;br /&gt;
&lt;br /&gt;
Table_array    is the table of information in which data is looked up. Use a reference to a range or a range name, such as Database or List.&lt;br /&gt;
&lt;br /&gt;
1. If range_lookup is TRUE, the values in the first column of table_array must be placed in ascending order: ..., -2, -1, 0, 1, 2, ..., A-Z, FALSE, TRUE; otherwise VLOOKUP may not give the correct value. If range_lookup is FALSE, table_array does not need to be sorted.&lt;br /&gt;
&lt;br /&gt;
2. You can put the values in ascending order by choosing the Sort command from the Data menu and selecting Ascending.&lt;br /&gt;
&lt;br /&gt;
3. The values in the first column of table_array can be text, numbers, or logical values.&lt;br /&gt;
&lt;br /&gt;
4. Uppercase and lowercase texts are equivalent.&lt;br /&gt;
&lt;br /&gt;
Col_index_num    is the column number in table_array from which the matching value must be returned. A col_index_num of 1 returns the value in the first column in table_array; a &lt;br /&gt;
col_index_num of 2 returns the value in the second column in table_array, and so on. If col_index_num is less than 1, VLOOKUP returns the #VALUE! error value; if col_index_num is greater than the number of columns in table_array, VLOOKUP returns the #REF! error value.&lt;br /&gt;
&lt;br /&gt;
Range_lookup    is a logical value that specifies whether you want VLOOKUP to find an exact match or an approximate match. If TRUE or omitted, an approximate match is returned. In other words, if an exact match is not found, the next largest value that is less than lookup_value is returned. If FALSE, VLOOKUP will find an exact match. If one is not found, the error value #N/A is returned.&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
Remarks&lt;br /&gt;
&lt;br /&gt;
1. If VLOOKUP can&#39;t find lookup_value, and range_lookup is TRUE, it uses the largest value that is less than or equal to lookup_value. &lt;br /&gt;
&lt;br /&gt;
2. If lookup_value is smaller than the smallest value in the first column of table_array, VLOOKUP returns the #N/A error value. &lt;br /&gt;
&lt;br /&gt;
3. If VLOOKUP can&#39;t find lookup_value, and range_lookup is FALSE, VLOOKUP returns the #N/A value. &lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
HLOOKUP&lt;br /&gt;
&lt;br /&gt;
This function searches for a value in the top row of a table or an array of values, and then returns a value in the same column from a row you specify in the table or array. Use HLOOKUP when your comparison values are located in a row across the top of a table of data, and you want to look down a specified number of rows. Use VLOOKUP when your comparison values are located in a column to the left of the data you want to find.&lt;br /&gt;
&lt;br /&gt;
The H in HLOOKUP stands for &quot;Horizontal.&quot;&lt;br /&gt;
&lt;br /&gt;
How does it work?&lt;br /&gt;
&lt;br /&gt;
HLOOKUP(lookup_value,table_array,row_index_num,range_lookup)&lt;br /&gt;
&lt;br /&gt;
Lookup_value    is the value to be found in the first row of the table. Lookup_value can be a value, a reference, or a text string.&lt;br /&gt;
&lt;br /&gt;
Table_array    is a table of information in which data is looked up. Use a reference to a range or a range name.&lt;br /&gt;
&lt;br /&gt;
1. The values in the first row of table_array can be text, numbers, or logical values.&lt;br /&gt;
&lt;br /&gt;
2. If range_lookup is TRUE, the values in the first row of table_array must be placed in ascending order: ...-2, -1, 0, 1, 2,... , A-Z, FALSE, TRUE; otherwise, HLOOKUP may not give the correct value. If range_lookup is FALSE, table_array does not need to be sorted.&lt;br /&gt;
&lt;br /&gt;
3. Uppercase and lowercase texts are equivalent.&lt;br /&gt;
&lt;br /&gt;
4. You can put values in ascending order, left to right, by selecting the values and then clicking Sort on the Data menu. Click Options, click Sort left to right, and then click OK. Under Sort by, click the row in the list, and then click Ascending.&lt;br /&gt;
&lt;br /&gt;
Row_index_num    is the row number in table_array from which the matching value will be returned. A row_index_num of 1 returns the first row value in table_array, a row_index_num of 2 returns the second row value in table_array, and so on. If row_index_num is less than 1, HLOOKUP returns the #VALUE! error value; if row_index_num is greater than the number of rows on table_array, HLOOKUP returns the #REF! error value.&lt;br /&gt;
&lt;br /&gt;
Range_lookup    is a logical value that specifies whether you want HLOOKUP to find an exact match or an approximate match. If TRUE or omitted, an approximate match is returned. In other words, if an exact match is not found, the next largest value that is less than lookup_value is returned. If FALSE, HLOOKUP will find an exact match. If one is not found, the error value #N/A is returned.&lt;br /&gt;
&lt;br /&gt;
Remarks&lt;br /&gt;
&lt;br /&gt;
1. If HLOOKUP can&#39;t find lookup_value, and range_lookup is TRUE, it uses the largest value that is less than lookup_value. &lt;br /&gt;
&lt;br /&gt;
2. If lookup_value is smaller than the smallest value in the first row of table_array, HLOOKUP returns the #N/A error value.&lt;/div&gt;</content><link rel='replies' type='application/atom+xml' href='http://excelsols.blogspot.com/feeds/7602538692775149529/comments/default' title='Post Comments'/><link rel='replies' type='text/html' href='http://excelsols.blogspot.com/2009/07/function-vlookup-hlookup.html#comment-form' title='0 Comments'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/8253737087368577623/posts/default/7602538692775149529'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/8253737087368577623/posts/default/7602538692775149529'/><link rel='alternate' type='text/html' href='http://excelsols.blogspot.com/2009/07/function-vlookup-hlookup.html' title='FUNCTION VLOOKUP &amp; HLOOKUP'/><author><name>Humayun</name><uri>http://www.blogger.com/profile/04097760079859273206</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='https://img1.blogblog.com/img/b16-rounded.gif'/></author><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-8253737087368577623.post-8930230300792573553</id><published>2009-07-09T12:33:00.007+06:00</published><updated>2012-02-17T16:31:26.273+05:00</updated><category scheme="http://www.blogger.com/atom/ns#" term="picking up the strings and values from the text"/><category scheme="http://www.blogger.com/atom/ns#" term="values from left"/><category scheme="http://www.blogger.com/atom/ns#" term="values from middle"/><category scheme="http://www.blogger.com/atom/ns#" term="values from right"/><category scheme="http://www.blogger.com/atom/ns#" term="values from the text"/><category scheme="http://www.blogger.com/atom/ns#" term="values in the text"/><title type='text'>FUNCTION LEFT, MID &amp; RIGHT</title><content type='html'>&lt;div dir=&quot;ltr&quot; style=&quot;text-align: left;&quot; trbidi=&quot;on&quot;&gt;LEFT &amp;amp; LEFTB&lt;br /&gt;
&lt;br /&gt;
LEFT returns the first character or characters in a text string, based on the number of characters you specify.&lt;br /&gt;
&lt;br /&gt;
LEFTB returns the first character or characters in a text string, based on the number of bytes you specify. This function is for use with double-byte characters.&lt;br /&gt;
&lt;br /&gt;
How does it work?&lt;br /&gt;
&lt;br /&gt;
=LEFT(text,num_chars)&lt;br /&gt;
=LEFTB(text,num_bytes)&lt;br /&gt;
&lt;br /&gt;
Text    is the text string that contains the characters you want to extract.&lt;br /&gt;
Num_chars specifies the number of characters you want LEFT to extract.&lt;br /&gt;
• Num_chars must be greater than or equal to zero.&lt;br /&gt;
• If num_chars is greater than the length of text, LEFT returns all of text.&lt;br /&gt;
• If num_chars is omitted, it is assumed to be 1.&lt;br /&gt;
&lt;br /&gt;
Num_bytes specifies the number of characters you want LEFTB to extract, based on bytes.&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
MID &amp;amp; MIDB&lt;br /&gt;
&lt;br /&gt;
MID returns a specific number of characters from a text string, starting at the position you specify, based on the number of characters you specify.&lt;br /&gt;
&lt;br /&gt;
MIDB returns a specific number of characters from a text string, starting at the position you specify, based on the number of bytes you specify. This function is for use with double-byte characters.&lt;br /&gt;
&lt;br /&gt;
How does it work?&lt;br /&gt;
&lt;br /&gt;
=MID(text,start_num,num_chars)&lt;br /&gt;
=MIDB(text,start_num,num_bytes)&lt;br /&gt;
&lt;br /&gt;
Text    is the text string containing the characters you want to extract.&lt;br /&gt;
&lt;br /&gt;
Start_num    is the position of the first character you want to extract in text. The first character in text has start_num 1, and so on.&lt;br /&gt;
&lt;br /&gt;
Num_chars    specifies the number of characters you want MID to return from text.&lt;br /&gt;
&lt;br /&gt;
Num_bytes    specifies the number of characters you want MIDB to return from text, in bytes.&lt;br /&gt;
&lt;br /&gt;
Remarks&lt;br /&gt;
• If start_num is greater than the length of text, MID returns &quot;&quot; (empty text). &lt;br /&gt;
• If start_num is less than the length of text, but start_num plus num_chars exceeds the length of text, MID returns the characters up to the end of text. &lt;br /&gt;
• If start_num is less than 1, MID returns the #VALUE! error value. &lt;br /&gt;
• If num_chars is negative, MID returns the #VALUE! error value.&lt;br /&gt;
• If num_bytes is negative, MIDB returns the #VALUE! error value.&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
RIGHT &amp;amp; RIGHTB&lt;br /&gt;
&lt;br /&gt;
RIGHT returns the last character or characters in a text string, based on the number of characters you specify.&lt;br /&gt;
&lt;br /&gt;
RIGHTB returns the last character or characters in a text string, based on the number of bytes you specify. This function is for use with double-byte characters.&lt;br /&gt;
&lt;br /&gt;
How does it work?&lt;br /&gt;
&lt;br /&gt;
=RIGHT(text,num_chars)&lt;br /&gt;
=RIGHTB(text,num_bytes)&lt;br /&gt;
&lt;br /&gt;
Text    is the text string containing the characters you want to extract.&lt;br /&gt;
&lt;br /&gt;
Num_chars    specifies the number of characters you want RIGHT to extract.&lt;br /&gt;
&lt;br /&gt;
Num_bytes specifies the number of characters you want RIGHTB to extract, based on bytes.&lt;br /&gt;
&lt;br /&gt;
Remarks&lt;br /&gt;
• Num_chars must be greater than or equal to zero. &lt;br /&gt;
• If num_chars is greater than the length of text, RIGHT returns all of text. &lt;br /&gt;
• If num_chars is omitted, it is assumed to be 1.&lt;/div&gt;</content><link rel='replies' type='application/atom+xml' href='http://excelsols.blogspot.com/feeds/8930230300792573553/comments/default' title='Post Comments'/><link rel='replies' type='text/html' href='http://excelsols.blogspot.com/2009/07/function-left-mid-right.html#comment-form' title='0 Comments'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/8253737087368577623/posts/default/8930230300792573553'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/8253737087368577623/posts/default/8930230300792573553'/><link rel='alternate' type='text/html' href='http://excelsols.blogspot.com/2009/07/function-left-mid-right.html' title='FUNCTION LEFT, MID &amp; RIGHT'/><author><name>Humayun</name><uri>http://www.blogger.com/profile/04097760079859273206</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='https://img1.blogblog.com/img/b16-rounded.gif'/></author><thr:total>0</thr:total></entry></feed>