Difference Between Formula, Function & Feature

-
ExcelBite 3

Comments

Post a Comment

Popular posts from this blog

GSTIN CheckSum Digit Logic

-
Image
Its always an adventure for a Professional to find & acquires the information which are lesser-known to generals. Each taxpayer is assigned a state-wise PAN-based 15-digit Goods and Services Taxpayer Identification Number (GSTIN). Here is a format break-down of the GSTIN: The first two digits represent the state code as per Indian Census 2011. The next ten digits will be the PAN number of the taxpayer The thirteenth digit will be assigned based on the number of registration within a state The fourteenth digit will be Z by default The last digit will be for check code. It may be an alphabet or a number. Lets have a Detailed View of Last Digit And Know How to Calculate this Digit Each Digit 0-9 is awarded with a weight from 0-9 & Each Alphabet {A-Z} have weight from 10 -35 Step I  - Assign Weight to Each Digit of GSTIN seperately Step II - Assign "Place Value Factor(PVF)" 1 for All Odd Place Value 2 for All Even Place Value Step I...
Read more

Answer for How to Display / Activate DEVELOPER tab in Excel? What is Use of Developer Tab in Excel

-
Image
Question:  In Microsoft Excel, how do I get the DEVELOPER tab at my ribbon? Answer:   To display the DEVELOPER tab, click on the File menu and then select  Options  from the drop down menu. When the Excel Options window appears, click on the  Customize Ribbon  option on the left. Click on the  Developer  checkbox under the list of Main Tabs on the right. Then click on the OK button. Now you should see the  DEVELOPER tab  in the toolbar at the top of the screen. All of the DEVELOPER tab option groups should be available - Code, Add-Ins, Controls, ML, and Modify (see below). Uses of Developer Tab: Write macros. Run macros that you previously recorded. Use XML commands. Use ActiveX controls. Create applications to use with Microsoft Office programs. Use form controls in Microsoft Excel. Work with the ShapeSheet in Microsoft Visio. Create new shapes and stencils in Microsoft Visio. ...
Read more

Spell-Number in Rupees Excel VBA Formula

-
Please open Virtual Basic using Developer toolbar or pressing shortcut Alt + F11 & Insert new Module from Insert Menu or by right click in Project Explorer. Copy the underneath program in the module. Now move to the excel workbook and try the Formula "=SpellNumber(<number>)" You will get the number converted in Words. For any query please do comment or mail me on Gauravj75@gmail.com Public Function SpellNumbers(ByVal MyNumber) Dim Rupees, Paise, Temp Dim DecimalPlace, Count ReDim Place(9) As String Place(2) = " Thousand " Place(3) = " Lac " Place(4) = " Crore " Place(5) = " Arab " ' String representation of amount MyNumber = Trim(Str(MyNumber)) ' Position of decimal place 0 if none DecimalPlace = InStr(MyNumber, ".") 'Convert Paise and set MyNumber to Rupee amount If DecimalPlace > 0 Then Paise = GetTens(Left(Mid(MyNumber, DecimalPlace + 1) & "00", 2)) MyNumber = Tr...
Read more