April 08, 2010

Deduct percentages in excel


Problem: How to deduct 3% or 10% as formulae in Excel?

=A*0,9
is for minus 10 percent

=A*0,97
is for minus 3 percent

1 comment:

Markus Schopenknecht said...

You dont have to do this manually, you cant just use excel functions for this. Takes a little to explain, so i just give you a link to a guide: http://www.excel-aid.com/excel-percentages-calculating-percentages.html. If you are new to excel this should be useful to you. Hope i could help.