Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 09-25-2011, 12:24 PM
doczilla doczilla is offline help with formula? Mac OS X help with formula? Office 2010 32bit
Novice
help with formula?
 
Join Date: Sep 2011
Posts: 2
doczilla is on a distinguished road
Default help with formula?

i have a whole bunch of numbers and i wanted to raise each number by 15%... how would i go about doing that?
Reply With Quote
  #2  
Old 09-25-2011, 12:57 PM
Colin Legg's Avatar
Colin Legg Colin Legg is offline help with formula? Windows 7 32bit help with formula? Office 2010 32bit
Expert
 
Join Date: Jan 2011
Location: UK
Posts: 369
Colin Legg will become famous soon enough
Default

Welcome to the board.


If you want to permanently increase the numbers by 15% then:
  • Type 0.15 into a spare, empty cell. Let's suppose this cell is cell Z1.
  • Select Z1 and press CTRL+C to copy it.
  • Select the cells containing the numbers which you want to increase.
  • Right click > paste special
  • In the Paste section choose Values. In the Operation section choose Multiply.
  • Click OK
  • All of the numbers will now be increased by 15%

If you want a formula to reference a given cell and provide a result which is 15% more then this will be the general outline:
=A1*15%
Reply With Quote
  #3  
Old 09-25-2011, 04:14 PM
doczilla doczilla is offline help with formula? Mac OS X help with formula? Office 2010 32bit
Novice
help with formula?
 
Join Date: Sep 2011
Posts: 2
doczilla is on a distinguished road
Default

thx a ton!!!!!!!!!!!
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
help with formula? Help with formula please. AndrewSE Excel 3 04-05-2011 08:50 PM
help with formula? PMT Formula OneOleGuy Excel 4 03-05-2011 09:54 AM
help with formula? Help with Formula Corca Excel 6 02-22-2010 09:40 PM
help with formula? If formula sixhobbits Excel 1 10-02-2009 08:02 AM
help with formula? Need help with a formula tinkertron Excel 11 04-16-2009 11:43 PM

Other Forums: Access Forums - Senior Forums

All times are GMT -7. The time now is 11:58 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2020, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2020 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft