Saturday, 2 May 2015

How to Calculate Percentage in Same Column in Excel

How to Calculate Percentage in Same Column in Excel Hi, guys welcome back again, today we will discus how to calculate increase or decrease percentage in Same Column in Microsoft Excel.  First we need to know what exactly we want, for example if you want to increase or decrease percentage of any value in the same particular column, just follow these steps.

For example: I have 40 and I want to add 10% extra of this 40 into the next column, type “=” in the column “select column” type “*” type your perchance (%), press “+” again select the same column and press “Enter”… Ooh… it’s not that much difficult, the simple formula is “=B4*10%+B4”. 
How to Calculate Percentage in Same Column in Excel
(please watch below video tutorial for easy understood)

For Minus percentage use the same formula for example; “=B4*10%-B4”. Instead of “+” type “-“
How to Calculate Percentage in Same Column in Excel




Watch video tutorial….. Please Like, share and subscribe