Correct formula for deduction of %

Copper Contributor

Hi,

  I am using a spreadsheet for a basic payroll for sub contractors and within this i am trying to deduct 20% from a cell value. Each time it will allow the multiplication of 20% but not the deduction of 20%

3 Replies

@Mark_74 

That's

=A1 - A1*20%
or
=A1*(1-20%)
or
=0.8*A1

 

Sergei,

             Thank you so much for your assistance with this that is a great help

@Mark_74 , you are welcome