Formula for subtracting percentages??

  • Thread starter Thread starter Elle
  • Start date Start date
E

Elle

I've forgotten how to subtract a certain percent from the values in my
spreadsheet, can somebody remind me please?

Thanks
 
I've forgotten how to subtract a certain percent from the values in my
spreadsheet, can somebody remind me please?
Click to expand...

If you want to subtract say 5% from all values, enter in an empty cell: 0.95
(ie 100%-5% = 95% = 0.95). Copy that cell, then select the values range,
right-click > paste special > check multiply > ok
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:19,500 Files:362 Subscribers:62
xdemechanik
---
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

I need to add multiple cells then subtract them from one cell c4+c6+c7+c9+c10+c11 and subtract them 1
Formula after division 1
subtracting in excel 1
Column sum incorrect upon subtracting 6
If Tuesday subtract 4 (Formulas) 3
How do I aucto subtract? 3
Excel Subtract text after the third space and before the fourth (from between spaces) 3
Excel Subtracting multiple columns from another column 3

Back
Top