LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #2   Report Post  
Peo Sjoblom
 
Posts: n/a
Default

One way, assume you want to add 17% to a rnage of cells, best might be to use
a help column and this formula

=A1*(1+17%)


copy down/across
that way you have an audit trail

otherwise put this formula in a cell

=1+17%

or just 117

copy the cell, select the range of cells, do editpaste special and check
multiply,
if you use the =1+17% you probably need to reformat the cells into either
currency or general


Regards,

Peo Sjoblom


"woody" wrote:

How do i increase multiple cells by using a percent formula?

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Is there any way to increase the colomns in Excel more than 256 ? sheshtar5212 Excel Discussion (Misc queries) 1 December 24th 04 12:27 PM
Increase the limit to number of columns? David Pharmacy 777 Excel Discussion (Misc queries) 4 December 15th 04 04:43 PM
Is there a way to have two values (percent and number) in a label. msmiller613 Charts and Charting in Excel 1 December 15th 04 03:47 AM
Increase Number of Worksheets Hoochi Coochi Man Excel Discussion (Misc queries) 4 December 10th 04 04:17 PM
calculate percent increase vlro Excel Discussion (Misc queries) 1 December 1st 04 02:35 PM


All times are GMT +1. The time now is 04:46 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"