Excel If Function with Calculations “IF function” can be used in complex calculations. See the example: If a sales executive sells more than 5 items, the company will pay incentive 40 rupees per item sold and if the sales executive sells less than 5 items, the company will pay 20 rupees per item sold. See…
Read more
Excel If Function The IF function or IF statement in Excel is composed of three parts separated by commas. A condition What to display if the condition is fulfilled What to display if the condition is not fulfilled See how the “IF function” is created step by step to find the safe and unsafe travelling…
Read more
Quick Excel Functions There are some quick functions in Excel that can provide you the statistics of your worksheet without using formulas such as Status Bar quick functions. See the image given below, as soon as you select the desired range you will get the statistics in the status bar, the average of numbers, the…
Read more
Instruction while typing data in excel Type the values and text in separate cells else the formula will not work. See the example given below: In case you want to add currency symbol to values then use mini toolbar as shown in the image given below. Select the range of cells then right click. Mini…
Read more
Excel Absolute Referencing Absolute referencing helps multiply multiple values with a particular value. See the image shown below. The list 1 values are multiplied by 4, value of cell C3. In this case, we will use symbol $ in the formula. So we have to modify the formula for that after entering the formula press…
Read more
Excel Relative Referencing Relative referencing tells that you don’t need to type the formula separately for each calculation in a column or a row. See the image: Type the formula in the first cell D3 and press Enter key to get the result, then use the fill handle. The formula will change automatically in the…
Read more
Excel Fill Handle in Formulas In the image given below, we want to multiply the numbers in column B with 5, so we can type the formula such as =B3*5 for cell B3 and other cells of the column B, but this is not possible with long lists. In such cases, we use Fill handle…
Read more
Excel Creating Formulas In cell C5 enter the number 20, now in cell E5 type the formula: =C5+5 then press the Enter key. You will get the result. The formula says 5 is added to the value entered in the cell C5 as the value is 20 the result is 25. See the image: In…
Read more
Excel Fill Handle with Dates Fill handle can be used to fill dates in multiple cells. If you need to enter a complete month in worksheet, you don’t need to type each date separately. Just choose a cell, type the date and using fill handle carry it over other cells, Excel will enter the subsequent…
Read more
Excel Fill Handle with Text and Numbers Fill handle also works with cells containing both text and number. In this case, the text does not change but the number increases by one for every cell you select. See the images: