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

Excel - Data Validation

-
Image
Introduction Data validation is a feature in Excel used to control what a user can enter into a cell. For example, you could use data validation to make sure a value is a number between 1 and 6, make sure a date occurs in the next 30 days, or make sure a text entry is less than 25 characters. Data validation can simply display a message to a user telling them what is allowed as shown below: Data validation can also stop invalid user input. For example, if a product code fails validation, you can display a message like this: In addition, data validation can be used to present the user with a predefined choice in a dropdown menu: This can be a convenient way to give a user exactly the values that meet requirements. Data validation controls Data validation is implemented via rules defined in Excel's user interface on the Data tab of the ribbon. Important limitation It is important to understand that data validation can be easily defeated. If a user copies d...
Read more