SMALL Formula in Excel

What Does It Do ?

This function examines a list of values and picks the value at a user specified position
in the list.

Syntax

=SMALL(ListOfNumbersToExamine,PositionToPickFrom)

Formatting

No special formatting is needed.

Example

The following table was used to calculate the bottom 3 sales figures between Jan, Feb and Mar.

Note
Another way to find the Highest and Lowest values would have been to use
the =MAX() and =MIN() functions.

SLN Formual in Excel

What Does It Do ?

This function calculates the Straight Line Depreciation of an item.
(Also known as Fixed Instalment method).

The Straight Line Depreciation is how much the value of an item reduced during a specific
period of time. The result is a uniform depreciation value.

An example would be if you bought a new car for £20,000, then kept it for 6 years.
At the end of your ownership you sell the car for £8,000.

The difference between the original and the trade in price is £20,000 - £8,000 which is £12,000.
Because you owned the car for 6 years, the SLN is calculated as £12,000 / 6 which is £2,000.

Syntax

=SLN(OriginalCost,SellingPrice,LengthOfOwnership)
The LengthOfOwnership can be any time period, days, months or years.
However, the SLN which is calculated will, be for that time, specifying 2 years ownership
as 24 months will give an SLN per month.

Formatting

No special formatting is needed.

SIGN Formula in Excel

What Does It Do ?

This function tests a value to determine whether it is positive or negative.
If the value is positive the result is 1.
If the value is negative the result is -1.
If the value is zero 0 the result is 0.

Syntax

=SIGN(CellToTest)

The CellToTest can be a cell or a calculation.

Formatting

No special formatting is needed.

SECOND Formula in Excel

What Does It Do?                        

The function will show the second of the minute based upon a time or a number.                        
Only the fraction part of the number is used as it is this which relates to time of day.                        
                        
Syntax                        
=SECOND(Number)                        
                        
Formatting                        
The result will be shown as a normal number between 0 and 59.                        
                        
Example                        

The following table was used by a telephone company to calculate the cost of a call.                        
The telephone company only deals in seconds which are a multiple of 5.                        
The seconds in a call are rounded up to the nearest multiple of 5 before the bill is calculated.                        
The Duration of the call is entered.                        
The =MINUTES() function calculates the total number of minutes.                        
The =SECOND() function calculates the total number of seconds.                        
The =CEILING() function rounds the seconds up to the nearest multiple of 5.                        
The Cost of the call is then calculated.        
               

How to extract hyperlink from Excel

If you have a list of items in an excel sheet and want to extract the hyperlink from each of this fields use the below method to do it.

First Just Copy the below formula

Function HyperLinkText(pRange As Range) As String

Dim ST1 As String
Dim ST2 As String

If pRange.Hyperlinks.Count = 0 Then
   Exit Function
End If

ST1 = pRange.Hyperlinks(1).Address
ST2 = pRange.Hyperlinks(1).SubAddress

If ST2 <> "" Then
   ST1 = "[" & ST1 & "]" & ST2
End If

HyperLinkText = ST1

End Function

To use this press Alt+F11 click on Insert then Module and paste the above code

Now just come to the excel sheet and In the next cell just type

=HyperLinkText(which cell u want to link)