ComputerFlicks

Use of ABS Functions in Microsoft Excel ABS Formula Syntax and usage in MS Excel explanation by ComputerFlicks… The easiest function of Excel, easy to use, and understand. If we need to get the absolute value irrespective of negative or positive, we can use ABS function . As a reference, we can use a number or a cell reference.   Let suppose we have huge data that contains positive and negative values, but our requirement is to get the sum of all values. For example, we have two values +20 and -20 , if we add both values it will be zero, instead of zero we want the sum of both values "40" . In such cases the first step is to use  ABS function and convert all values into absolute values, after getting absolute values, we can add both values and we will get the output "40" . Syntax:   = ABS (number) We place the number of which we want the absolute value. In the place of no we can also select the cell reference in the excel sheet. Imag

Use of "IF" Formula in easy form. MS Excel – “IF” Formula Explanation By Computer Flicks … In order to understand easily we have divided the if formula in multiply example (Simple to Hard) Definition : IF formula is very popular function among excel formulas, it is a logical function biased on true and false value. We have to create a logic between the values. In logical function we can put two condition, result will display as per true and false defined values. According to logic, value can hit the true or false condition and the result will display accordingly. Simple Example: If  (Cell A:1 is Blank , then print 1, otherwise print 2 ) The above example is for your understanding, the correct syntax is given below. The function is divided in three parts. In the first Part we have to define a logic. if cell A:1 is blank then, the true value will print or reflect  "1"  as output and if A:1 is not blank then the false value will print "2&qu

Microsoft Excel – Short Cut Keys. Some important Excel Short Cut Keys. If you are a daily excel user, you must know some short cut keys to get a good speed over your reporting with excel sheets. In this article we have defined short cut keys depends on your requirement. Some of the short cut keys you must know. Make a habit to use short cut keys to improve your work style with excel. Some of the keys are not limited to Microsoft Excel but you can use it with MS Word and any other application also. We have divided this article into three parts. First is basic short cut keys, second is the text formatting and third is Good to know if you want to learn. The first and second parts are important to learn.   Let's see the table below and start learning.   Image: 1 - Microsoft Excel Short Cut Keys. See the Excel short cut keys above. We have defined only important excel short cut which is important for daily use. Please post a comment or any suggestion in the below com