How to correct a #DIV/0! error in excel with Kutools

Hello friends , one of my viewer Requested me to solve this Error. Here i gave you a explanation about
#DIV/0! error from microsoft page.

What is  #DIV/0! error in excel ?

Excel displays the #DIV/0! error when a number is divided either by zero (0) or by a cell that contains no value.

Symptom

Excel displays the #DIV/0! error in one or more cells on a worksheet.

Causes

Entering a formula that performs explicit division by zero (0) — for example, =5/0.
Using a reference to a blank cell or to a cell that contains zero as the divisor in a formula or function that performs division.
Running a macro that uses a function or a formula that returns the #DIV/0! error.

Calculate Your Current Age with the Excel DATEDIF Function/How to Calculate Age on Excel

Age Calculation Formula (DATEDIF) 

Calculate your age by using DATEDIF Function.

1. =DATEDIF(A2,NOW(),"y")
2. =DATEDIF(A2,TODAY(),"y")
3. =DATEDIF(A6,B6,"y") & "years"

Click here for more formula help

How to Get Characters With Excel CHAR Function

Learn How to use Char function(formula) in microsoft excel,check the above image to know the characters will appear for particular number.

The formula is very simple =char(), here  () you  can update 1 to 255 numbers to get characters,

For example if you update the Number 128 in formula = char (128) the result will be €.

Click here to learn by video completely here. check the below image for step by step with explanation.

How to use LEN function in excel 2007

What is LEN function in excel ???

The LEN (length) function returns  the number of characters in a text string. you can see the below image to know more.

Len function calculates the value which you selected + spaces & , & . Etc. for example i have selected my page name which i typed in excel, the result is 25 means its calculated characters as well as full stop (.)
the same thing for spaces also. check the  below animated image to learn the function.

How to Compare Cells With Excel EXACT Function / how to use exact function in excel

What is the use of Exact Function in excel ?

Exact function helps us to match (or) compare the values in  two columns/cells in excel. Before going to enter the formulas please note that exact functions are case-sensitive,means if the 1st column values are in the uppercase & the 2 ed  column values in lowercase. then the formula will show false result.

So before going to start putting formula's to your values change the Case-Sensitive of your entire sheet for better result.

Click here to learn how to change Case-Sensitive in excel

Now Let we see how to use Exact Function in excel.Please follow the pictures to learn & please put a comment about picture quality.if you are not happy with the Picture animation please let me know to do something.

Go to formulas tab select text & click exact the screen with you are looking in the image Function Arguments will appear. just select the text which you want to know the result & click ok.

Above & the below picture will explain you differences between the text 1 & text 2 .

Here the formula in zoom effect. = Exact(B6,C6)

I hope this picture helped you to learn exact function.also you can see my video for exact function Right here

How to change Case-sensitive in Ms.Excel/how to change words into upper (or) lower case in excel

Hello Guys, Today i am going to explain about Case-Sensitive in Microsoft Excel.Before that i want say you  in Microsoft word there is an option to change the characters in to Uppercase (or) Lowercase. check the figure right now below.

But in excel we need to use formula to change Uppercase to Lowercase & the same for Lowercase to Uppercase.its a very simple formula to kept in memory.below  check the below animated image to learn how i use those formulas to change Case-Sensitive.

Hope you guys are understood sure.let me know about your thoughts.put a comment below.

How to combine two columns in excel 2007 (Text version)/learn how to merge two column into one in excel 2007

Learn how to combine 2 column into one column

Combining two columns into one  column is simply easy. use this simple formula

=A4&B4

Checkout my video version here

How to combine two columns in excel 2007 (Video)

How to create the sample function Called Spell Number in excel ???

Learn How to create the sample function Called SpellNumber

1. Start Microsoft Excel.
2. Press ALT+F11 to start the Visual Basic Editor.
3. On the Insert menu, click Module.
4. Type the following code into the module sheet.

   Option Explicit
   'Main Function
   Function SpellNumber(ByVal MyNumber)
       Dim Dollars, Cents, Temp
       Dim DecimalPlace, Count
       ReDim Place(9) As String
       Place(2) = " Thousand "
       Place(3) = " Million "
       Place(4) = " Billion "
       Place(5) = " Trillion "
       ' String representation of amount.
       MyNumber = Trim(Str(MyNumber))
       ' Position of decimal place 0 if none.
       DecimalPlace = InStr(MyNumber, ".")
       ' Convert cents and set MyNumber to dollar amount.
       If DecimalPlace > 0 Then
           Cents = GetTens(Left(Mid(MyNumber, DecimalPlace + 1) & _
                     "00", 2))
           MyNumber = Trim(Left(MyNumber, DecimalPlace - 1))
       End If
       Count = 1
       Do While MyNumber <> ""
           Temp = GetHundreds(Right(MyNumber, 3))
           If Temp <> "" Then Dollars = Temp & Place(Count) & Dollars
           If Len(MyNumber) > 3 Then
               MyNumber = Left(MyNumber, Len(MyNumber) - 3)
           Else
               MyNumber = ""
           End If
           Count = Count + 1
       Loop
       Select Case Dollars
           Case ""
               Dollars = "No Dollars"
           Case "One"
               Dollars = "One Dollar"
            Case Else
               Dollars = Dollars & " Dollars"
       End Select
       Select Case Cents
           Case ""
               Cents = " and No Cents"
           Case "One"
               Cents = " and One Cent"
                 Case Else
               Cents = " and " & Cents & " Cents"
       End Select
       SpellNumber = Dollars & Cents
   End Function
         
   ' Converts a number from 100-999 into text 
   Function GetHundreds(ByVal MyNumber)
       Dim Result As String
       If Val(MyNumber) = 0 Then Exit Function
       MyNumber = Right("000" & MyNumber, 3)
       ' Convert the hundreds place.
       If Mid(MyNumber, 1, 1) <> "0" Then
           Result = GetDigit(Mid(MyNumber, 1, 1)) & " Hundred "
       End If
       ' Convert the tens and ones place.
       If Mid(MyNumber, 2, 1) <> "0" Then
           Result = Result & GetTens(Mid(MyNumber, 2))
       Else
           Result = Result & GetDigit(Mid(MyNumber, 3))
       End If
       GetHundreds = Result
   End Function
         
   ' Converts a number from 10 to 99 into text. 
   Function GetTens(TensText)
       Dim Result As String
       Result = ""           ' Null out the temporary function value.
       If Val(Left(TensText, 1)) = 1 Then   ' If value between 10-19...
           Select Case Val(TensText)
               Case 10: Result = "Ten"
               Case 11: Result = "Eleven"
               Case 12: Result = "Twelve"
               Case 13: Result = "Thirteen"
               Case 14: Result = "Fourteen"
               Case 15: Result = "Fifteen"
               Case 16: Result = "Sixteen"
               Case 17: Result = "Seventeen"
               Case 18: Result = "Eighteen"
               Case 19: Result = "Nineteen"
               Case Else
           End Select
       Else                                 ' If value between 20-99...
           Select Case Val(Left(TensText, 1))
               Case 2: Result = "Twenty "
               Case 3: Result = "Thirty "
               Case 4: Result = "Forty "
               Case 5: Result = "Fifty "
               Case 6: Result = "Sixty "
               Case 7: Result = "Seventy "
               Case 8: Result = "Eighty "
               Case 9: Result = "Ninety "
               Case Else
           End Select
           Result = Result & GetDigit _
               (Right(TensText, 1))  ' Retrieve ones place.
       End If
       GetTens = Result
   End Function
        
   ' Converts a number from 1 to 9 into text. 
   Function GetDigit(Digit)
       Select Case Val(Digit)
           Case 1: GetDigit = "One"
           Case 2: GetDigit = "Two"
           Case 3: GetDigit = "Three"
           Case 4: GetDigit = "Four"
           Case 5: GetDigit = "Five"
           Case 6: GetDigit = "Six"
           Case 7: GetDigit = "Seven"
           Case 8: GetDigit = "Eight"
           Case 9: GetDigit = "Nine"
           Case Else: GetDigit = ""
       End Select
   End Function
        

How to use the SpellNumber sample function

To use the sample functions to change a number to written text, use one of the methods demonstrated in the following examples:

Method 1: Direct Entry

You can change 32.50 into "Thirty Two Dollars and Fifty Cents" by entering the following formula into a cell:

=SpellNumber(32.50)

Method 2: Cell reference

You can refer to other cells in the workbook. For example, enter the number 32.50 into cell A1, and type the following formula into another cell:

=SpellNumber(A1)

Source