By using Macro we can record a task. It is very beneficial when you have a task that you need to do frequently. It speeds up the process and guarantees correctness. How to open a macro: Open View tab. On the top right end of the Ribbon you will find the macro button. Click on … Read more
The ISNA() function could be a logical function that returns the value in True / False. It checks whether or not the argument is #N/A error or not. It keeps one parameter that’s a value. Where to use : ISNA() operate is extremely helpful to manage #N/A error value over excel sheets. Syntax : =ISNA(value) … Read more
The IF function or IF statement in Excel is collected of three parts separated by commas. A condition What to show if the condition is matched What to show if the condition is not matched See how the “IF function” is created step by step to find the safe and unsafe travelling speeds in the … Read more
IF function” can be used in complex calculations. See the example: If a business developer, generate leads more than 3, the company will give incentive 1000 rupees per lead generation and if the business developer generate leads less than 3, then company will give incentive 500 rupees per lead. See in what way the “IF … Read more
Cartesian product is determined by the two words that comprise the same. The word Cartesian is said to be derived from the name of a French Philosopher and mathematician René Descartes. The Cartesian product of any two non empty sets say A and B would be denoted and determined as A x B. Also, it … Read more
The fill handle is a useful Excel tool that is used to fill data with a particular form. You can spread a sequence of numbers, dates and text groupings to preferred number of cells. To use fill handle bring the mouse pointer at right bottom corner of the cell it will turn out to be … Read more
Fill handle also works with cells holding both text and number. In this case, the text does not change but the number increases by one for every cell you choose. See the pictures:
Fill handle in Excel can be used to fill dates in multiple cells. If you want to put a whole month in spreadsheet, you don’t want to type every date individually. Just select a cell, type the date and using fill handle transmit it over next cells, Excel will enter the succeeding dates in the … Read more
In the image given below, we want to Addition & multiply the numbers in column D Addition with 10 and Multiplication by 3, so we can type the formula for addition as =D5+10 and for multiplication =D5*3 cell D5 and other cells of the column D, but this is not possible with long lists. In … Read more
In cell D7 put the number 10, now in cell F7 type the formula: =D7+10 then press the Enter key. You will see the result. The formula says 10 are added to the data entered in the cell D7 as the value is 10 the result is 20. See the image: In a similar method … Read more