ExcelTip.com
Account Icon Account Icon Account Icon
ExcelTip.com

Go Back   Excel Help Forum > Usenet Groups > Excel 2007 Help

Notices

Reply
 
Thread Tools Search this Thread Display Modes
  #1  
Old 09-05-2008, 12:25 PM
Dxiong Dxiong is offline
Registered User
 
Join Date: 04 Sep 2008
Location: Wisconsin
Posts: 8
Dxiong is on a distinguished road
Exel 2007 formula increase by percentage increments

Hi,
I really need help on this formula please. An example is if A1 is 2300 I need B1 = A1+10% of A1, and I want C1 = A1+20% of A1. C1 = A1+30% of A1. formual needs to be increase by 10% of A1.
Please help):
dxiong

Last edited by VBA Noob; 09-05-2008 at 01:52 PM.
Reply With Quote
  #2  
Old 09-05-2008, 12:41 PM
daddylonglegs's Avatar
daddylonglegs daddylonglegs is offline
Forum Moderator
 
Join Date: 14 Jan 2006
Location: England
Posts: 4,979
daddylonglegs will become famous soon enough daddylonglegs will become famous soon enough
Try putting this formula in B1.....then copy it across as far as you need

=A1+$A1*10%
Reply With Quote
  #3  
Old 09-05-2008, 02:13 PM
Dxiong Dxiong is offline
Registered User
 
Join Date: 04 Sep 2008
Location: Wisconsin
Posts: 8
Dxiong is on a distinguished road
Thank you so much..the formula that you give me works great..

Thanks again..
dxiong
Reply With Quote
Reply

Bookmarks

New topics in Excel 2007 Help


Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

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

Similar Threads
Thread Thread Starter Forum Replies Last Post
Percentage Formula print4422 Excel Miscellaneous 2 02-19-2007 06:41 PM
formula to increase a number by 10%? ruffridder9 Excel Miscellaneous 10 02-19-2007 05:13 PM
% of Increase - Decrease - Formula Desert Piranha Excel Miscellaneous 12 01-24-2007 07:02 PM
help with percentage formula pumperley Excel - New Users 6 10-12-2006 10:33 PM


All times are GMT -4. The time now is 03:22 PM.


Powered by vBulletin® Version 3.7.3
Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.
Search Engine Friendly URLs by vBSEO 3.2.0