Correct formula for deduction of %

%3CLINGO-SUB%20id%3D%22lingo-sub-1352214%22%20slang%3D%22en-US%22%3ECorrect%20formula%20for%20deduction%20of%20%25%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1352214%22%20slang%3D%22en-US%22%3E%3CP%3EHi%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%20I%20am%20using%20a%20spreadsheet%20for%20a%20basic%20payroll%20for%20sub%20contractors%20and%20within%20this%20i%20am%20trying%20to%20deduct%2020%25%20from%20a%20cell%20value.%20Each%20time%20it%20will%20allow%20the%20multiplication%20of%2020%25%20but%20not%20the%20deduction%20of%2020%25%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1352214%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1352240%22%20slang%3D%22en-US%22%3ERe%3A%20Correct%20formula%20for%20deduction%20of%20%25%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1352240%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F447329%22%20target%3D%22_blank%22%3E%40Mark_74%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EThat's%3C%2FP%3E%0A%3CPRE%20class%3D%22lia-code-sample%20language-applescript%22%3E%3CCODE%3E%3DA1%20-%20A1*20%25%0Aor%0A%3DA1*(1-20%25)%0Aor%0A%3D0.8*A1%3C%2FCODE%3E%3C%2FPRE%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1352414%22%20slang%3D%22en-US%22%3ERe%3A%20Correct%20formula%20for%20deduction%20of%20%25%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1352414%22%20slang%3D%22en-US%22%3E%3CP%3ESergei%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3BThank%20you%20so%20much%20for%20your%20assistance%20with%20this%20that%20is%20a%20great%20help%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1352470%22%20slang%3D%22en-US%22%3ERe%3A%20Correct%20formula%20for%20deduction%20of%20%25%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1352470%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F447329%22%20target%3D%22_blank%22%3E%40Mark_74%3C%2FA%3E%26nbsp%3B%2C%20you%20are%20welcome%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
New 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
Highlighted

@Mark_74 

That's

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

 

Highlighted

Sergei,

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

Highlighted

@Mark_74 , you are welcome