percenatge increase in values across multiple cells

D

David

Hi

I have a spreadsheet of numerical values and I simply want to increase all
values, in all cells, by 17.5%. Can anyone please tell me how to do this?

Many thanks
David
 
N

Nick Hodge

David

Type 1.175 in a spare cell and copy it... Highlight your numbers and then
edit>paste special...>values+multiply

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
www.nickhodge.co.uk
(e-mail address removed)
 
D

David

Many thanks for this. Saved me a lot of mouse work! Why the help couldn't
explain this I don;t know...too concerned with complex things and forgets
the fundamentals.

Cheers
David
 

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

Need Help with Macro Security 1
Word macro that can call cells out of Excel for a find and replace 0
Calculate the median value before a specified list 0
Excel does not accept text format! 0
Copy addition formula of non-consecutive horizontal cells 2
External cell reference between two excel worksheets both in One Drive 0
Increasing the value of the content of cells by one. 2
Would like to input 3 letters into a cell, each having a different numerical value 5

Top