Learn about excel running total, power, gcd, datedif formula

How to use RUNNING TOTAL formula?

Running total means the total sum of previous all cells total + current cell. Suppose you have 5 cells. Current cell number is 4. So running total for 4 number cell is, summation of the previous 3 cells and current cell(4 no cell).

Now if you drag to the end then you will get a running total for other cells. In the example we can see, for the first cell the summation is the existing value, because there is no value present before the first cell value. So At first write the first cell value and then in the second cell write the formula.

How to use POWER() formula?

To calculate the power of any value this function used.

Here the first parameter is the cell number for which cell value you want to calculate power and second parameter is for power value. Here pass the number which you want to use as the power value.

Formula: =POWER(cell,power)

Now to apply for other cells just drag it to the end

How to use GCD() formula?

This function is used to calculate the ratio. Here first you need two columns to calculate ratio. One column is for GCD value and another column is for calculating the ratio.

Formula: =GCD(cell,cell,cell,.....)
Here select all those cells for which you want to calculate the ratio.

Formula of calculate ratio after finding GCD:
=first cell/GCD value cell &”:”& second cell/GCD value cell Here at first select the cell and divide with GCD value.

Now to apply for other cells just drag it to the end

How to use DATEDIF() formula?

This function is used to find the age, month, year, days of a person. To work with this function you must know the starting date and ending date.

Formula: =DATEDIF(start date cell,end date cell,"Y")
To calculate year use Y, for month use YM, and for day use "MD".

To apply for other cells just drag it to the end