Learn with Manish Shori

  MATCH Function Summary In MS Excel there are lot of lookup functions that can find a certain value in a range of cells, MATCH is one of them. Basically, it identifies a relative position or location of any item in a given range in the cells. But it has also a limitation that if there is a duplicate value, it gives the result which is found in the first number. MATCH can find or you can say that it supports only approximate, exact and Wildcard (* ?) matches. MATCH is an Excel function used to locate the first position of a lookup value in a row, column or table. Often the INDEX function is combined with MATCH to retrieve the value at the position returned by MATCH. Purpose Get the position of an item in an array Return value A number representing a position in lookup_array. Syntax =MATCH (lookup_value, lookup_array, [match_type]) Arguments • lookup_value - The value to match in lookup_array. • lookup_array - A range of cells or an array reference. • match_type - [This is optiona

  ROUND Function in Excel  Summary The Excel ROUND function returns a number rounded to a given number of digits. The  ROUND function can round to the right or left of the decimal point. Purpose Round a number to a given number of digits Return value A rounded number. Syntax =ROUND (number, num_digits) Here, =ROUND (A2, B2) // Result is in C2 The formula is The result is Arguments               • number - The number to round. • num_digits - The number of digits to which number should be rounded. Usage notes • The ROUND function rounds a number to a given number of places. The number of places to  round to is controlled by the number of digits provided to ROUND, as seen in the table below:  Example 1 - round to right To round values to the right of the decimal point, use a positive number for digits:  =ROUND(A1,1) // Round to 1 decimal place =ROUND(A2,2) // Round to 2 decimal places =ROUND(A2,3) // Round to 3 decimal places =ROUND(A2,4) // Round to 4 decimal places

Overview to Gateway of Tally Introduction Do you know what is Gateway of Tally? You must know the meaning of Gateway of Tally as it the menu that opens up every time you open Tally . But do you want to know the best part about Gateway of Tally? It is its simplicity and division of functions in a way so that you can understand Tally with ease. Gateway of Tally is divided into four different components. They are: ·          Masters ·          Transactions ·          Utilities ·          Reports Masters There are two options in Masters in Gateway of Tally. They are: · Accounts Info. · Inventory Info. Accounts Info. Accounts Info. includes everything about ledgers, groups of different ledgers, budgets, scenarios, voucher types and statutory info. In other words, anything accounting apart from passing entries has to be done through Accounts Info. If you want to create or alter a new ledger, you have to go through Accounts Info. or if you want to create a new voucher type,