percentage

[Steve96]

Hi
new to this...

can anyone help ? how do i deduct 20%
i have a work sheet running at the moment and i need to deduct 20%
from my list prices ?
i can do it on a calculator but it would be much easier with a sum


thanks

 

[Dazza7]

Calculate %

Hi Steve,

Same way as you would on a calculator.

But in formula it would be =SUM(B4/100*20)

B4 being the cell with your prices

so you could have 3 columns your prices the percentage column with the above formula then another column where you subtract the % of the prices.

Or if you prefer in swoop =B4-SUM(B4/100*20)

 

[Steve96]

%

Thank You

That is just what i needed

Steve